Windows Mysql乱码

来源：互联网发布：淘宝追加评论哪里看编辑：程序博客网时间：2024/05/23 01:59

新建一份my.ini，并添加以下内容后重启服务

[mysqld]character-set-server=utf8[mysql]default-character-set=utf8

作用

mysqld用途为修改服务器相关编码character_set_database、character_set_server设置为utf8mysql用途为修改客户端相关编码character_set_client、character_set_connection、character_set_results设置为utf8

查看mysql编码

mysql> show variables like 'character%';+--------------------------+----------------------------------------+| Variable_name            | Value                                  |+--------------------------+----------------------------------------+| 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       | D:\mysql-5.6.20-winx64\share\charsets\ |+--------------------------+----------------------------------------+8 rows in set (0.05 sec)

导入sql数据依旧是乱码

将sql文件用记事本打开，保存编码为utf8，再source导入即可。

0 0