解决思路:
1、数据库字符集是否正确,设为utf-8
查看数据库编码:
show variables like '%char%';
修改字符编码:(可直接设为全局的,在set后➕global)
set character_set_server=utf8;
set character_set_database=utf8;
show variables like '%char%';
2、代码层面 代码连接时设置为utf-8
在路径后面➕“?useUnicode=true&characterEncoding=utf-8”
3、修改完没起作用的话,重启mysql服务。
启动MySQL服务 sudo /usr/local/MySQL/support-files/mysql.server start
停止MySQL服务 sudo /usr/local/mysql/support-files/mysql.server stop
重启MySQL服务 sudo /usr/local/mysql/support-files/mysql.server restart