mysql> use demodb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>
mysql> show variables like 'character\_set\_%';
+--------------------------+--------+
| 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 |
+--------------------------+--------+
7 rows in set (0.00 sec)
mysql> set character_set_client=utf8;
Query OK, 0 rows affected (0.01 sec)
mysql> show variables like 'character\_set\_%';
+--------------------------+--------+
| Variable_name | Value |
+--------------------------+--------+
| character_set_client | utf8 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
+--------------------------+--------+
7 rows in set (0.00 sec)
mysql> select * from project;
+-------+------------+------+--------------+-------------+-----------+----------+--------------+--------+
| ID | pname | URL | LEAD | DESCRIPTION | pkey | pcounter | ASSIGNEETYPE | AVATAR |
+-------+------------+------+--------------+-------------+-----------+----------+--------------+--------+
| 10200 | demo | NULL | aaa | NULL | DEMO | 159 | 2 | 10011 |
| 10300 | demo2 | NULL | bbb | NULL | DEMOTWO | 1 | 2 | 10011 |
| 10302 | ?????? | | ccc | | FFF | 0 | 2 | 10011 |
| 10500 | ???? | NULL | aaa | NULL | QQQ | 11 | 2 | 10011 |
| 10501 | SCRUM-???? | NULL | ddd | NULL | SFFF | 24 | 2 | 10011 |
| 10502 | ?????? | NULL | eee | NULL | SSS | 6 | 2 | 10011 |
| 10504 | ???? | NULL | fff | NULL | FINANCING | 2 | 2 | 10011 |
+-------+------------+------+--------------+-------------+-----------+----------+--------------+--------+
7 rows in set (0.00 sec)
mysql>
mysql> set character_set_connection=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_database=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_results=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_server=utf8;
Query OK, 0 rows affected (0.00 sec)
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 | utf8 |
| character_set_system | utf8 |
+--------------------------+--------+
7 rows in set (0.00 sec)
mysql> select * from project;
+-------+--------------------+------+--------------+-------------+-----------+----------+--------------+--------+
| ID | pname | URL | LEAD | DESCRIPTION | pkey | pcounter | ASSIGNEETYPE | AVATAR |
+-------+--------------------+------+--------------+-------------+-----------+----------+--------------+--------+
| 10200 | demo | NULL | aaa | NULL | DEMO | 159 | 2 | 10011 |
| 10300 | demo2 | NULL | bbb | NULL | DEMOTWO | 1 | 2 | 10011 |
| 10302 | 实例项目需求 | | ccc | | FFF | 0 | 2 | 10011 |
| 10500 | 演示项目 | NULL | ddd | NULL | QQQ | 11 | 2 | 10011 |
| 10501 | SCRUM-实例项目 | NULL | eee | NULL | SFFF | 24 | 2 | 10011 |
| 10502 | 正式A需求 | NULL | fff | NULL | SSS | 6 | 2 | 10011 |
| 10504 | 正式T | NULL | ddd | NULL | FINANCING | 2 | 2 | 10011 |
+-------+--------------------+------+--------------+-------------+-----------+----------+--------------+--------+
7 rows in set (0.00 sec)
通过以上过程说明.仅仅通过set character_set_client=utf8;是不能解决乱码问题的.解决乱码问题需要把mysql的服务器编码设置成utf8,同时,创建数据库的时候需要把数据库的编码设置成utf8编码,才能解决mysql数据库查询乱码问题.
如果数据库服务器的编码是utf8,而数据库的编码也是utf8,在客户端查询出现乱码,基本上可以推断是客户端的设置不是utf8编码.
数据库服务编码设置请参见mysql服务端编码设置.
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>
mysql> show variables like 'character\_set\_%';
+--------------------------+--------+
| 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 |
+--------------------------+--------+
7 rows in set (0.00 sec)
mysql> set character_set_client=utf8;
Query OK, 0 rows affected (0.01 sec)
mysql> show variables like 'character\_set\_%';
+--------------------------+--------+
| Variable_name | Value |
+--------------------------+--------+
| character_set_client | utf8 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
+--------------------------+--------+
7 rows in set (0.00 sec)
mysql> select * from project;
+-------+------------+------+--------------+-------------+-----------+----------+--------------+--------+
| ID | pname | URL | LEAD | DESCRIPTION | pkey | pcounter | ASSIGNEETYPE | AVATAR |
+-------+------------+------+--------------+-------------+-----------+----------+--------------+--------+
| 10200 | demo | NULL | aaa | NULL | DEMO | 159 | 2 | 10011 |
| 10300 | demo2 | NULL | bbb | NULL | DEMOTWO | 1 | 2 | 10011 |
| 10302 | ?????? | | ccc | | FFF | 0 | 2 | 10011 |
| 10500 | ???? | NULL | aaa | NULL | QQQ | 11 | 2 | 10011 |
| 10501 | SCRUM-???? | NULL | ddd | NULL | SFFF | 24 | 2 | 10011 |
| 10502 | ?????? | NULL | eee | NULL | SSS | 6 | 2 | 10011 |
| 10504 | ???? | NULL | fff | NULL | FINANCING | 2 | 2 | 10011 |
+-------+------------+------+--------------+-------------+-----------+----------+--------------+--------+
7 rows in set (0.00 sec)
mysql>
mysql> set character_set_connection=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_database=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_results=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_server=utf8;
Query OK, 0 rows affected (0.00 sec)
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 | utf8 |
| character_set_system | utf8 |
+--------------------------+--------+
7 rows in set (0.00 sec)
mysql> select * from project;
+-------+--------------------+------+--------------+-------------+-----------+----------+--------------+--------+
| ID | pname | URL | LEAD | DESCRIPTION | pkey | pcounter | ASSIGNEETYPE | AVATAR |
+-------+--------------------+------+--------------+-------------+-----------+----------+--------------+--------+
| 10200 | demo | NULL | aaa | NULL | DEMO | 159 | 2 | 10011 |
| 10300 | demo2 | NULL | bbb | NULL | DEMOTWO | 1 | 2 | 10011 |
| 10302 | 实例项目需求 | | ccc | | FFF | 0 | 2 | 10011 |
| 10500 | 演示项目 | NULL | ddd | NULL | QQQ | 11 | 2 | 10011 |
| 10501 | SCRUM-实例项目 | NULL | eee | NULL | SFFF | 24 | 2 | 10011 |
| 10502 | 正式A需求 | NULL | fff | NULL | SSS | 6 | 2 | 10011 |
| 10504 | 正式T | NULL | ddd | NULL | FINANCING | 2 | 2 | 10011 |
+-------+--------------------+------+--------------+-------------+-----------+----------+--------------+--------+
7 rows in set (0.00 sec)
通过以上过程说明.仅仅通过set character_set_client=utf8;是不能解决乱码问题的.解决乱码问题需要把mysql的服务器编码设置成utf8,同时,创建数据库的时候需要把数据库的编码设置成utf8编码,才能解决mysql数据库查询乱码问题.
如果数据库服务器的编码是utf8,而数据库的编码也是utf8,在客户端查询出现乱码,基本上可以推断是客户端的设置不是utf8编码.
数据库服务编码设置请参见mysql服务端编码设置.
本文转自博客园zhyiwww 的博客,原文链接:http://www.blogjava.net/zhyiwww/,如需转载请自行联系原博主。