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...