MYSQL DOS插入中文报错

Question

我是新手 今天在MySQL里面插入中文报错，我上网查了一下说改my.ini 改了也没用 运行 set names gbk 也没用 那位大哥指点下

Answer 1

字符集问题
show variables like 'char%'; 

Answer 2

+--------------------------+----------------------------------------------------
-----+
| Variable_name            | Value
     |
+--------------------------+----------------------------------------------------
-----+
| character_set_client     | utf8
     |
| character_set_connection | utf8
     |
| character_set_database   | latin1
     |
| 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\chars
ets\ |

Answer 3

错误信息是什么？建表语句是什么？尽可能贴出全部信息以供别人分析。
参考下贴中的检查方法贴出你的检查结果。
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码

Answer 4

错误信息是ERROR 1366 (HY000): Incorrect string value: '\xBA\xCE\xC4\xCB\xB3\xAC' for colum
n 'user_name' at row 1

Answer 5

字符集不统一
试试
set names latin1

Answer 6

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                                |
| character_sets_dir       | D:\MySQL Server 5.1\share\charsets\ |
+--------------------------+-------------------------------------+
8 rows in set (0.00 sec)mysql> insert into asd values(11,'周');
ERROR 1366 (HY000): Incorrect string value: '\xD6\xDC' for column 'name' at row
1
mysql> set names gb2312;
Query OK, 0 rows affected (0.00 sec)mysql> insert into asd values(11,'周');
Query OK, 1 row affected (0.01 sec)mysql> select * from asd where name ='周';
+------+------+
| id   | name |
+------+------+
|   10 | 周     |
|   11 | 周     |
+------+------+
2 rows in set (0.00 sec)mysql>

Answer 7

在MY.INI的MYSQLD，CLIENT下添加default-character-set=UTF8，重新启动服务，再插入汉字。