mysql-5.1.38 中文问题

Question

mysql-5.1.38，用的no-install的zip包，成功启动了。
然后用Toad for mysql连，没法向表里插入中文数据。后来换了mysql官网上的GUI Tool试，也是不行。
插入英文数据就没问题。应该怎么解决呢？

Answer 1

安装SQLYOG试试，估计是字符集问题show variables like 'char%'; 

Answer 2

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码

Answer 3

字符集问题Toad for mysql默认的是utf8编码
你在toad for mysql上执行set names utf8然后再试插数据看看

Answer 4

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     | utf8                                                    |
| character_set_system     | utf8                                                    |
| character_sets_dir       | C:\Program Files\MySQL\MySQL Server 5.1\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set (0.00 sec)
看看字符集 
一致不

Answer 5

OK了，谢谢各位。my.cnf文件设置为如下即可：[mysqld]
basedir=C:/mysql-5.1.38-win32
datadir=C:/mysql-5.1.38-win32/data
character-set-server=utf8[mysql]
default-character-set=utf8
当然，通过Toad for MySQL也可以修改variables。