重新配置MYSQL的字符集为UTF8

Question

重新配置MYSQL的字符集为UTF8。难道这个字符集不识别中文？
mysql> create database china;
Query OK, 1 row affected (0.00 sec)mysql> drop database china;
Query OK, 0 rows affected (0.06 sec)mysql> create database 中国;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '中国'
 at line 1
mysql> create database '中国';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ''中国
'' at line 1

Answer 1

mysql> show variables like 'char%';
+--------------------------+-------------------------------------+
| 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       | D:\MySQL Server 5.1\share\charsets\ |
+--------------------------+-------------------------------------+
8 rows in set (0.00 sec)mysql> create database `中国`
    -> ;
Query OK, 1 row affected (0.20 sec)mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| 中国               |

Answer 2

你可以设置为gbk或者gb2312 在选择字符集的时候需要慎重一些.不然你会遇到一些比较郁闷的问题.

Answer 3

1楼你用的什么版本的。发给我一个 [email protected]

Answer 4

1楼贴错了
mysql> show variables like 'char%';
+--------------------------+-------------------------------------+
| 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       | D:\MySQL Server 5.1\share\charsets\ |
+--------------------------+-------------------------------------+
8 rows in set (0.00 sec)mysql> create database `中国`;
ERROR 1300 (HY000): Invalid utf8 character string: '中国'
mysql> set names gbk;
Query OK, 0 rows affected (0.00 sec)mysql> show variables like 'char%';
+--------------------------+-------------------------------------+
| Variable_name            | Value                               |
+--------------------------+-------------------------------------+
| character_set_client     | gbk                                 |
| character_set_connection | gbk                                 |
| character_set_database   | utf8                                |
| character_set_filesystem | binary                              |
| character_set_results    | gbk                                 |
| character_set_server     | utf8                                |
| character_set_system     | utf8                                |
| character_sets_dir       | D:\MySQL Server 5.1\share\charsets\ |
+--------------------------+-------------------------------------+
8 rows in set (0.00 sec)mysql> create database `中国`;
Query OK, 1 row affected (0.00 sec)

Answer 5

4楼用的还是GBK字符集啊！！ 那不用发了

Answer 6

UTF8支持中文，不过WINDOWS下的DOS并不能良好的支持UTF。参考下贴中的方法解决。
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码

Answer 7

windows下dos不地utf8字符。只能用gbk了。
你换到ubuntu下就能用utf8了。

Answer 8

建议还是用utf8，这样通用性好一些！