mysql utf8mb4 支持emoji表情
测试环境
1、修复my.cnf 配置编码
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
2、修复php程序mysql连接编码
完成以上两步后发现mysql报 SQLSTATE[HY000] [2019] Can't initialize character set utf8mb4
解决方法
yum erase php56w-mysql
yum install php56w-mysqlnd
Leave a Comment