Emoji data in MySQL

Supported MySQL 5.5, 5.6.

First, MySQL should set DB and table to utf8mb4.

utf8 - 3 byte characters

utf8mb4 - 4 byte characters

1
2
3
4
5
ALTER DATABASE my_database DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

ALTER TABLE my_table DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE my_column CHANGE my_column my_column TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;

Then, when inserting data or selecting data, execute this statement first:

1
2
3
4
5
--Execute this statement first
SET NAMES utf8mb4;

--then insert or select
SELECT * FROM my_table