php mysql set utf8_php和mysql数据库编码都是utf8,为什么还要set names utf8???

php是utf8编码(无论html编码还是php文件编码都是utf8)mysql数据库字符集也是utf8为什么这样也要mysql_query('SETNAMESUTF8')????????mysql>showvariableslike'%char%';+-------------...

php是utf8编码(无论html编码还是php文件编码都是utf8)

mysql数据库字符集也是utf8

为什么这样也要mysql_query('SET NAMES UTF8')????????

mysql> show variables like '%char%';

+--------------------------+--------------------------------------------------+

| 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 | /*/share/mysql/charsets/ |

+--------------------------+--------------------------------------------------+

8 rows in set

展开