MySQL存储Emoji表情

Problems with utf8 character set, should use utf8mb4

Apply to whole table:
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin

Or apply to a column
ALTER TABLE table_name CHANGE column_name VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin