MySQL+PHP出现乱码 在用mysql客户端时显示字符集如下:
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+PHP中:echo mysql_client_encoding();
显示的是:latin1
??phpmysql乱码
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+PHP中:echo mysql_client_encoding();
显示的是:latin1
??phpmysql乱码
如果你确定是UTF8那估计也不需要运行那个语句
mysql_query("set names utf8");
这条语句的功能大概就是临时改变以下要执行的SQL的字符集,应该是大于全局的
mysqld --default-character-set=utf8
| character_set_client | utf8 |
character_set_connection
character_set_results
这几个是基于连接的, 就是说对同一个数据库的不同的连接可以有不同的设置. 你可以看见mysql_client_encoding有一个可选参数就是连接资源. 所以, mysql客户端的, 和你php程序的, 可以不同, 所以如果缺省的不是你需要的, 那么就要在连接数据库后, set names