MYSQL 一个很怪的问题 想不通

Question

本帖最后由 sytdeedee 于 2011-07-12 10:23:08 编辑

Answer 1

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

Answer 2

这样的：mysql> show variables like 'char%';
+--------------------------+---------------------------------------------------------+
| Variable_name            | Value                                                   |
+--------------------------+---------------------------------------------------------+
| character_set_client     | latin1                                                  |
| character_set_connection | latin1                                                  |
| character_set_database   | latin1                                                  |
| character_set_filesystem | binary                                                  |
| character_set_results    | latin1                                                  |
| character_set_server     | latin1                                                  |
| character_set_system     | utf8                                                    |
| character_sets_dir       | D:\Program Files\MySQL\MySQL Server 5.1\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set

Answer 3

我试了一下用hex转换，情况如下：mysql> select hex('表示');
+------------+
| hex('表示') |
+------------+
| 958EA6     |
+------------+
1 row in setmysql> select unhex('958EA6');
+-----------------+
| unhex('958EA6') |
+-----------------+
| 侮ｦ              |
+-----------------+
1 row in set
mysql> select hex('表\示');
+-------------+
| hex('表\示') |
+-------------+
| 955C8EA6    |
+-------------+
1 row in setmysql> select unhex('955C8EA6');
+-------------------+
| unhex('955C8EA6') |
+-------------------+
| 表示               |
+-------------------+
1 row in set也就是说用“表示”的16进制码转换回去是乱码，而用“表\示”的16进制码转换回去反而会得到正确结果。

Answer 4

应该是你客户端字符集的问题set names gbk;

Answer 5

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