我的系统是Ubuntu 16.04,
mysql是5.7,
试过很多方法,没什么用,最后还是要修改文件...最不喜欢的操作
只需要修改一个文件即可,
命令行输入
find / -name my.cnf
找到我们需要修改的文件my.cnf
我这里看到有不同地址的3个,就不列出了
我个人选择了/ect/mysql/my.cnf这个文件
vi进去修改,直接将需要的参数
[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'
添加到末尾
ZZ保存退出,重启mysql
然后进入mysql,输入以下命令查看
SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
如出现以下信息,即可储存emoji字符
+--------------------------+--------------------+
| Variable_name | Value |
+--------------------------+--------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| collation_connection | utf8mb4_unicode_ci |
| collation_database | utf8mb4_unicode_ci |
| collation_server | utf8mb4_unicode_ci |
+--------------------------+--------------------+