当前位置: 代码迷 >> PHP >> show variables在phpmyadmin 跟 cls下结果不同
  详细解决方案

show variables在phpmyadmin 跟 cls下结果不同

热度:731   发布时间:2013-06-25 23:45:42.0
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\ |
  相关解决方案