为什么用[\u4e00-\u9fa5]匹配的是非中文？

[yangfanzn]

mysql> select '中文' regexp '[\u4e00-\u9fa5]';
+---------------------------------+
| '中文' regexp '[\u4e00-\u9fa5]' |
+---------------------------------+
|                               0 |
+---------------------------------+
1 row in set (0.00 sec)

mysql> select 'zw' regexp '[\u4e00-\u9fa5]';
+-------------------------------+
| 'zw' regexp '[\u4e00-\u9fa5]' |
+-------------------------------+
|                             1 |
+-------------------------------+
1 row in set (0.00 sec)

mysql> select '中文' not regexp  '[\u4e00-\u9fa5]';
+--------------------------------------+
| '中文' not regexp  '[\u4e00-\u9fa5]' |
+--------------------------------------+
|                                    1 |
+--------------------------------------+
1 row in set (0.00 sec)

为什么跟我理解的正好相反？？

[ACMAIN_CHM]

检查一下字符集设置。

[yangfanzn]

引用 1 楼 ACMAIN_CHM 的回复:

检查一下字符集设置。

+--------------------------+-----------------------------------------------+
| Variable_name            | Value                                         |
+--------------------------+-----------------------------------------------+
| character_set_client     | gbk                                           |
| character_set_connection | gbk                                           |
| character_set_database   | latin1                                        |
| character_set_filesystem | binary                                        |
| character_set_results    | gbk                                           |
| character_set_server     | latin1                                        |
| character_set_system     | utf8                                          |
| character_sets_dir       | e:\wamp\bin\mysql\mysql5.5.20\share\charsets\ |
+--------------------------+-----------------------------------------------+

数据库用的是utf8 请问应该怎么设置呢?

[ACMAIN_CHM]

引用 2 楼 yangfanzn 的回复:

[quote=引用 1 楼 ACMAIN_CHM 的回复:] 检查一下字符集设置。

+--------------------------+-----------------------------------------------+
| Variable_name            | Value                                         |
+--------------------------+-----------------------------------------------+
| character_set_client     | gbk                                           |
| character_set_connection | gbk                                           |
| character_set_database   | latin1                                        |
| character_set_filesystem | binary                                        |
| character_set_results    | gbk                                           |
| character_set_server     | latin1                                        |
| character_set_system     | utf8                                          |
| character_sets_dir       | e:\wamp\bin\mysql\mysql5.5.20\share\charsets\ |
+--------------------------+-----------------------------------------------+

数据库用的是utf8 请问应该怎么设置呢?[/quote]显然不是UTF8

[yangfanzn]

引用 3 楼 ACMAIN_CHM 的回复:

[quote=引用 2 楼 yangfanzn 的回复:]
[quote=引用 1 楼 ACMAIN_CHM 的回复:]
检查一下字符集设置。

+--------------------------+-----------------------------------------------+
| Variable_name            | Value                                         |
+--------------------------+-----------------------------------------------+
| character_set_client     | gbk                                           |
| character_set_connection | gbk                                           |
| character_set_database   | latin1                                        |
| character_set_filesystem | binary                                        |
| character_set_results    | gbk                                           |
| character_set_server     | latin1                                        |
| character_set_system     | utf8                                          |
| character_sets_dir       | e:\wamp\bin\mysql\mysql5.5.20\share\charsets\ |
+--------------------------+-----------------------------------------------+

数据库用的是utf8

请问应该怎么设置呢?[/quote]显然不是UTF8[/quote]


整理那里不是 utf8-bin么？这不算是utf8格式么？

[yangfanzn]

问题解决了，不是什么字符集设置的问题的 具体看下面的连接 http://bbs.csdn.net/topics/390111997

[yangfanzn]

什么原因呀，求关注呀