ubuntu 16.04 mysql 无法插入表情字符

1.在/etc/mysql/my.cnf 后面插入

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/

[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

可以用navicat或者命令修改数据库  和表 还有字段的字符集

2.重启 service mysql restart

3.代码连接池字符编码改成utf8mb4

4.如果是用navicat客户端 要在客户端执行

set names utf8mb4;  然后在客户端才能直接执行sql语句

5.更改后插入表情变成了？  有待改善