查看数据库字符集状态:
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/
如对本文有疑问, 点击进行留言回复!!
SSD原理及Pytorch代码解读——网络架构(二):特征提取网络及总体计算过程
集合类 ArrayList 和 LinkedList 直接用 Innodb(MySQL 5.0
网友评论