1),修改数据库的编码为utf8bm4 # vi/etc/my.cnf
[客户]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=& # 39;设置名称utf8mb4& # 39;
重启服务
systemctl重启mysqld.service
2),修改数据表的编码为utf8bm4
mysql>改变数据库voice_reports_test字符集utf8mb4核对utf8mb4_general_ci;
mysql>ALTER TABLE ZSCC_WRK_BSE_CKLCC转换为字符集utf8mb4核对utf8mb4_bin;,
显示变量在Variable_name像& # 39;字符\ _set \ _ % & # 39;或者Variable_name & # 39;排序% & # 39;;
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +
| Variable_name,,,,,|值大敌;,,,,,,|
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +
| character_set_client,,| utf8mb4,,,,,,|
| character_set_connection | utf8mb4,,,,,,|
| character_set_database,| utf8mb4,,,,,,|
| character_set_filesystem |二进制,,,,,,|
| 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 |
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +
10行组(0.00秒)
3),修改连接数据库的连接代码