Mysql database stores emoji and mysqlemoji expressions

Mysql database stores emoji and mysqlemoji expressions

Emoji needs to use the encoding format not utf8mb4, mysql database version more than 5.5, I use 5.6, because only 5.5 and above support utf8mb4.

1. SET the DATABASE encoding to utf8mb4. If utf8 is specified during DATABASE creation, execute the statement: alter database database_name character set = utf8mb4 COLLATE = utf8mb4_unicode_ci;

2. Change character_set_server in the database configuration parameter to utf8mb4.

3. Set the field encoding of the emoji expression to utf8mb4_unicode_ci.

4. After the configuration is complete, the emoji can be perfectly stored.