Emoji with MySQL
Emoji is using 4 byte Unicode. MySQL 5.5 support 4 byte character. You need to change
- Make sure all your tables' default character sets and text fields are converted to utf8mb4 ( eg. ALTER TABLE mytable charset=utf8mb4 )
- Before Insert or SELECT query , need SET NAMES utf8mb4 first.
ref: http://stackoverflow.com/questions/7814293/how-to-insert-utf-8-mb4-characteremoji-in-ios5-in-mysql
