MySQL5.0.16乱码问题处理办法

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

 

 1设置phpMyAdmin

Language:Chinesesimplified(zh-utf-8)
MySQL字符集：UTF-8Unicode(utf8)
MySQL连接校对gbk_chinese_ci

 2创建数据库时

整理设置成gbk_chinese_ci

 3用SQL建立表中

ENGINE=MyISAMDEFAULTCHARSET=gbk;
ENGINE=InnoDBDEFAULTCHARSET=gbkAUTO_INCREMENT=40;

 4检查表结构中

varchar(100)的整理属性为gbk_chinese_ci
其它类型的整理属性为空

 5代码中加上

$db->query("SETCHARACTERSETGBK");Linux下需要，Windows下不需要
这个相当于ConnectionCharacterSetsandCollations

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>