mysql乱码问题

MySQL命令符：

在navicat里有“工具”菜单。然后点击 “命令行界面”。

查看MySQL编码：

mysql>show variables like 'character\_set\_%';

非正常：

 

+--------------------------+--------+
| 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 | latin1 |
| character_set_system | utf8 |
+--------------------------+--------+

 

正常：

+--------------------------+--------+
| 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 |
+--------------------------+--------+

 

修改mysql的配置路径：

MySQL\MySQL Server 5.0\bin\MySQLInstanceConfig.exe