首頁  >  文章  >  後端開發  >  show variables在phpmyadmin 跟 cls下结果不同

show variables在phpmyadmin 跟 cls下结果不同

WBOY
WBOY原創
2016-06-13 12:45:55816瀏覽

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> 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>
陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn