日期:2014-05-17  浏览次数:20430 次

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      &n