web 项目从数据库读取数据时出现乱码的问题的解决

1.修改数据库的编码方式：

mysql> show variables like '%char%';
+--------------------------+--------------------------
| Variable_name            | Value
+--------------------------+--------------------------
| character_set_client     | utf8
| character_set_connection | utf8
| character_set_database   | gbk
| character_set_filesystem | binary
| character_set_results    | utf8
| character_set_server     | utf8
| character_set_system     | utf8
| character_sets_dir       | D:\DB\Mysql\share\charset
+--------------------------+--------------------------
8 rows in set (0.01 sec)

mysql> set character_set_client=gbk;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_connection=gbk;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_results=gbk;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_server=gbk;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_system=gbk;

mysql> show variables like '%char%';
+--------------------------+-----------------------------+
| Variable_name            | Value                       |
+--------------------------+-----------------------------+
| character_set_client     | gbk                         |
| character_set_connection | gbk                         |
| character_set_database   | gbk                         |
| character_set_filesystem | binary                      |
| character_set_results    | gbk                         |
| character_set_server     | gbk                         |
| character_set_system     | utf8                        |
| character_sets_dir       | D:\DB\Mysql\share\charsets\ |
+--------------------------+-----------------------------+

8 rows in set (0.00 sec)

设置成utf-8对比设置成 gbk的不同：

主要还是在  dos-cmd的默认 是gbk的编码。。。

所以使用gbk这种编码是比较好处理数据，不容易出现乱码问题

。。。。。。。。。。。。。。。。

改为utf-8

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:\DB\Mysql\share\charsets\ |
+--------------------------+-----------------------------+
8 rows in set (0.03 sec)

对于gbk 和 utf-8的编码不同     请查看：

http://www.cnblogs.com/xiaomia/archive/2010/11/28/1890072.html