mysql support utf8mb4

mysql.support.utf8mb4

https://mathiasbynens.be/notes/mysql-utf8mb4

my.cnf
...
[client]
default-character-set = utf8mb4

[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
...

# For each database:
ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
# For each table:
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# For each column:
ALTER TABLE table_name MODIFY column_name VARCHAR(xxx) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;