首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > PHP >

show variables在phpmyadmin 跟 cls下结果不同

2013-06-25 
show variables在phpmyadmin 和 cls下结果不同?语句 show variables like char%为什么phpmyadmin 和 cl

show variables在phpmyadmin 和 cls下结果不同?
语句 show variables like 'char%';
为什么phpmyadmin 和 cls下结果不同

phpmyadmin


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 latin1
character_set_system utf8
character_sets_dir C:\Program Files\MySQL\MySQL Server 5.1\share\char...
 


cls

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     | latin1                                                  |
| character_set_system     | utf8                                                    |
| character_sets_dir       | C:\Program Files\MySQL\MySQL Server 5.1\share\charsets\ |


+--------------------------+---------------------+
8 rows in set (0.00 sec)




[解决办法]
因为 phpmyadmin 在执行 show variables like 'char%'; 前
先执行了 set names utf8

热点排行