黑框和我们用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%';