MySQL中文乱码解决方案转自我的新浪博客

 

打开my.ini

[mysqld]段已设置为：default-character-set=utf8

执行下列语句，看看结果是不是下面的：
mysql> show variables like '%character%';
+--------------------------+-------------------------------------------+
| Variable_name            | Value                                     |
+--------------------------+-------------------------------------------+
| character_set_client     | latin1                                    |
| character_set_connection | latin1                                    |
| character_set_database   | utf8                                      |
| character_set_results    | latin1                                    |
| character_set_server     | utf8                                      |                  

| character_set_system     | utf8                                      |
| character_sets_dir       | C:/Program Files/MySQL/MySQL Server 4.1/share/charsets/ |
+--------------------------+-------------------------------------------+

mysql> show variables like '%collation%';
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database   | utf8_general_ci   |
| collation_server     | utf8_general_ci   |
+----------------------+-------------------+

 当然了，任意一张表里只要有中文就不会显示出来。代替中文的是一个"？"。以前的解决办法，在调用表里的数据前，在命名窗口设置如下：

set character_set_client = gbk;

set character_set_connection = gbk;

set character_set_results = gbk;

但当Mysql重新启动后，一切有回到原样。

 

网上查了相关资料，说是修改[mysql]字段 default-character-set=gbk ,发现my.ini中没有这个字段。也没找到my.cnf文件。

 

自己在my.ini中修改如下：

# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]

port=3306
default-character-set=gbk//这个部分是我增加的，其余没改动。

# SERVER SECTION
# ----------------------------------------------------------------------

 

检查如下：

mysql> show variables like '%character%';
+--------------------------+-------------------------------------------+
| Variable_name            | Value                                     |
+--------------------------+-------------------------------------------+
| character_set_client     | gbk                                       |
| character_set_connection | latin1                                    |
| character_set_database   | utf8                                      |
| character_set_results    | latin1                                    |
| character_set_server     | utf8                                      | 

| character_set_system     | utf8                                      |
| character_sets_dir       | C:/Program Files/MySQL/MySQL Server 4.1/share/charsets/ |
+--------------------------+-------------------------------------------+
mysql> show variables like '%collation%';
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | gbk_chinese_ci    |
| collation_database   | utf8_general_ci   |
| collation_server     | utf8_general_ci   |
+----------------------+-------------------+

 

结果是成功的，但不知原因