Hexagora Forum
Hexagora Forum
Home | Profile | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other hexagora products
 Programs (Programmi)
 [HELP] unicode to utf8 conversion
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sfi_dev
Practical

37 Posts

Posted - 10 Jul 2012 :  09:52:45  Show Profile  Visit sfi_dev's Homepage  Reply with Quote
hi, when converting from unicode to utf8, the utf8 representation can be quite a bit longer than the unicode text especially when double byte is involved.

So for example #30011;#20687;#26908;#32034; converts to 12 utf8 characters ????.

Has anyone written a formula or found a way to reduce the length of the produced utf8 characters so they can fit into existsing tables without having to increase table columns ?

Thank-you.

Julie

s.dav
Site Admin

Italy
3364 Posts

Posted - 11 Jul 2012 :  08:57:53  Show Profile  Visit s.dav's Homepage  Reply with Quote
Umm, very difficult; if you talk about numbers or IP numbers you can save some bytes using a base 64 to 128 encoding, but when talking about text I don't know.

Regards, Davide
Go to Top of Page

sfi_dev
Practical

37 Posts

Posted - 11 Jul 2012 :  11:20:52  Show Profile  Visit sfi_dev's Homepage  Reply with Quote
yeah I thought so.. to ensure integrity I am better off increasing the table sizes.. Thanks anyway :)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Hexagora Forum © s.dav Go To Top Of Page
Snitz Forums 2000