当前位置:Gxlcms > PHP教程 > showvariables在phpmyadmin跟cls下结果不同

showvariables在phpmyadmin跟cls下结果不同

时间:2021-07-01 10:21:17 帮助过:22人阅读

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\ |

人气教程排行