期待大家帮忙,牛X你就来,PHP插入mysql乱码,都设置了,还是不行
xoxyy 2011-02-24 02:55:52 PHP插入到mysql中的数据从终端到phpmyadmin浏览都是乱码,大家帮忙分析
环境:LAMP
1.mysql编码设置如下:
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
2. mysql 全局设置如下:
/etc/my.cnf
[client]
default-character-set='utf8'
[mysqld]
default-character-set='utf8'
3.PHP连接编码设置如下:
function db_connect()
{
$result=new mysqli('IP','db','user','passwd');
mysql_query("SET NAMES 'UTF8'");
4. PHP页面编码设置如下:
<meta http-equiv="Content-Type" content="text/html; charset=utf8">
能设置的都设置了,为什么在phpmyadmin 与终端里浏览还是乱码!!!!!
PS: phpmyadmin 与终端里也设置了编码为UTF8
哪位朋友帮忙解决一下。成分感谢!