mysql存储表情解决方式

1、对/etc/my.cnf作如下修改：
[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect=‘SET NAMES utf8mb4’

重启Mysql
service mysql stop（注意，修改my.cnf前先停止mysql）
service mysql start

2、将已经建好的表和字段也转换成utf8mb4
ALTER TABLE marketing.user DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

ALTER TABLE szwh.customers CHANGE COLUMN HEAD HEAD varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL;