XAMPP
目录D:\xampp\mysql\bin下的my.ini文件(151~156行)默认配置
## UTF 8 Settings
#init-connect=\'SET NAMES utf8\'
#collation_server=utf8_unicode_ci
#character_set_server=utf8
#skip-character-set-client-handshake
#character_sets-dir="D:/xampp/mysql/share/charsets"
show variables like“character_set_% 输入命令查看系统变量参数设置如下
修改my.ini文档当中上述设置中的第2行和第4行为:
## UTF 8 Settings
init-connect=\'SET NAMES utf8\'
#collation_server=utf8_unicode_ci
character_set_server=utf8
#skip-character-set-client-handshake
#character_sets-dir="D:/xampp/mysql/share/charsets"
关闭mysql重新启动之后再次查看系统变量如下:
show variables like“character_set_% 输入命令查看系统变量参数设置如下