查看数据库字符集状态:
- show VARIABLES like '%char%'
复制代码
查看结果:
- character_set_client utf8
- character_set_connection utf8
- character_set_database utf8
- character_set_filesystem binary
- character_set_results utf8
- character_set_server latin1
- character_set_system utf8
- character_sets_dir /usr/share/mysql/charsets/
复制代码
上面的字符集有一个是latin1,要修改为utf-8.
解决方式:
到服务器/etc/mysql/mysql.conf.d找到mysqld.cnf
在[mysqld] 下新增
- character_set_server=utf8 #增加这一行,指定字符集
复制代码
重启数据库:
- sudo service mysql restart
复制代码
再次查看字符集:
- character_set_client utf8
- character_set_connection utf8
- character_set_database utf8
- character_set_filesystem binary
- character_set_results utf8
- character_set_server utf8
- character_set_system utf8
- character_sets_dir /usr/share/mysql/charsets/
复制代码