show variables在phpmyadmin 跟 cls下结果不同

php中文网

发布： 2016-06-13 12:45:55

原创

1115人浏览过

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><a style="color:#f60; text-decoration:underline;" title="mysql" href="https://www.php.cn/zt/15713.html" target="_blank">mysql</a>&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>

登录后复制