修改mysql的默认字符集

s 查看mysql的字符集

把server characterset和db characterset修改成utf8

在my.ini的mysqld下面添加两行代码,重启mysql

[mysql]

default-character-set=utf8

[mysqld]

character-set-server = utf8
collation_server = utf8_general_ci

原文地址:https://www.cnblogs.com/qiandu/p/5473021.html