php5与mysql5.0数据写入中文乱码问题，在线等！

Question

如题，渴望各位高手指点！

Answer 1

没用过mysql,但建议看一下数据库的字符集设置，这个经常被忽略

Answer 2

先查看一下你数据库的字符集设置好没有
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       | D:\MySQL\MySQL 5.0\share\charsets\ |
+--------------------------+------------------------------------+
8 rows in set (0.18 sec)

Answer 3

我设置过了，结果是这样的，可还是不能正常读写mysql> show variables like "%char%";
+--------------------------+------------------------------------+
| Variable_name            | Value                              |
+--------------------------+------------------------------------+
| character_set_client     | gbk                                |
| character_set_connection | gbk                                |
| character_set_database   | gbk                                |
| character_set_results    | gbk                                |
| character_set_server     | gbk                                |
| character_set_system     | utf8                               |
| character_sets_dir       | D:\PhpServer\MySql\share\charsets\ |
+--------------------------+------------------------------------+
7 rows in set (0.03 sec)

Answer 4

连接上mysql后首先执行下面的语句:mysql_query("set names gbk");

Answer 5

连接后设置的字符集必须和服务器的字符集一致才行
就像楼上说的set names gbk
建议使用utf8编码

Answer 6

这是我总结的一些解决方案，不知对LZ有帮助没
1： 安装MySQL数据库时候就指定字符集合为gbk或者gb2312,只要数据库中显示正常中文字符的话，页面肯定显示正常，哪来这么多的转换，烦死了！！
2： 指定服务器的 编码   GBK   或者GB23123： 修改安装目录下的  初始化配置文件   my.ini# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir="E:/MySQL5/"#Path to the database root
datadir="E:/MySQL5/Data/"# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1             换成  gbk   或者  gb2312# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB