Mysql 5.7 配置允许存入emoji

[mysqld]
character-set-server=utf8mb4

[mysql]
default-character-set=utf8mb4

只要修改my.ini(位置:C:ProgramDataMySQL)文件,然后重启mysql服务即可.

注意数据库的编码为utf8mb4

SHOW VARIABLES LIKE 'character_set%';