Wednesday, February 29, 2012

Re: Sending emoticons from iPhone to CakePHP but received blank value

I have get some advice bellow:

MySQL before version 5.5 only supports UTF-8 for the BMP, which includes characters between U+0000 and U+FFFF. 
It cannot store the character at code point U+1F604 or other similar "high characters". MySQL 5.5+ supports utf8mb4utf16 and utf32
which are able to encode these characters. If you're using MySQL 5.5+, use one of these column character sets. 

If you are on MySQL < 5.5, you'll have to use a BLOB column type. That type stores raw bytes without caring about the "characters" in it. 
The downside is that you won't be able to efficiently search or index the text. 

What I have just confirmed now is that emoticons would be stored correctly after changed the field type from varchar to blob in our MySQL 5.1.54

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

No comments: