Home > Article > Backend Development > show variables在phpmyadmin 跟 cls下结果不同
show variables在phpmyadmin 和 cls下结果不同?
语句 show variables like 'char%';
为什么phpmyadmin 和 cls下结果不同
phpmyadmin
<br /> Variable_name Value<br /> character_set_client utf8<br /> character_set_connection utf8<br /> character_set_database utf8<br /> character_set_filesystem binary<br /> character_set_results utf8<br /> character_set_server latin1<br /> character_set_system utf8<br /> character_sets_dir C:\Program Files\MySQL\MySQL Server 5.1\share\char...<br />
<br> mysql> show variables like 'char%';<br> +--------------------------+---------------------+<br> | Variable_name | Value |<br> +--------------------------+---------------------+<br> | character_set_client | latin1 |<br> | character_set_connection | latin1 |<br> | character_set_database | utf8 |<br> | character_set_filesystem | binary |<br> | character_set_results | latin1 |<br> | character_set_server | latin1 |<br> | character_set_system | utf8 |<br> | character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.1\share\charsets\ | <div class="clear"> </div>