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 utf8mb4, utf16 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 [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
