Home  >  Article  >  Backend Development  >  show variables在phpmyadmin 跟 cls下结果不同

show variables在phpmyadmin 跟 cls下结果不同

WBOY
WBOYOriginal
2016-06-13 12:45:55796browse

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>
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article: apache 配备 https Next article: 又是正则.多谢啊