show variables在phpmyadmin 跟 cls下结果不同-php教程-PHP中文网

show variables在phpmyadmin 跟 cls下结果不同

php中文网

发布： 2016-06-13 11:25:28

原创

1345人浏览过

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

登录后复制

cls

<br>mysql&gt; 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>

登录后复制