mysql乱码问题

黑框和我们用php取数据原理是一样的，都是客户端

黑框乱码

黑框只认识gbk码，在黑框中通过使用”set names gbk″, 就告诉服务器, 我用的是gbk编码, 我希望你也给我返回gbk编码的查询结果

//黑框设置
mysql> show variables like '%char%';
+--------------------------+-------------------------------------+
| Variable_name            | Value                               |
+--------------------------+-------------------------------------+
| character_set_client     | latin1                              |
| character_set_connection | latin1                              |
| character_set_database   | utf8                                |
| character_set_filesystem | binary                              |
| character_set_results    | latin1                              |
| character_set_server     | utf8                                |
| character_set_system     | utf8                                |
| character_sets_dir       | F:\wamp\mysql5.5.27\share\charsets\ |
+--------------------------+-------------------------------------+
8 rows in set (0.00 sec)

mysql> set character_set_client=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_connection=gbk;
Query OK, 0 rows affected (0.00 sec)



//上面的一堆设置等同于
 set names gbk;
/*它相当于下面的代码
set character_set_client=gbk;
set character_set_results=gbk;
set character_set_connection=gbk;
*/

浏览器乱码

//php设置
mysql_query('set names utf8',$con);

show variables like '%char%';