以下所描述无理论依据，纯属经验谈。

MySQL使用4.1以上版本，管他是什么字符集，一律使用默认。不用去设置MySQL。

然后举个使用GB2312和UTF-8的例子。

好，你只要保证你的写着INSERT SQL语句的PHP文件编码为GB2312，恭喜你，你使用写着SELECT SQL语句的GB2312编码的PHP文件读取出来的数据也是GB2312的。
同理，只要你插入数据库的PHP文件是UTF-8编码，那么你录入的就是UTF-8的，读取出来同样使用编码为UTF-8的读取。

如果我录入为GB2312，显示要使用UTF-8怎么办?

如果你的所有PHP文件为UTF-8编码，那么你在INSERT的时候，就必须使用iconv进行编码转换，将str转为GB2312入库，读取也一样，使用iconv转为UTF-8显示。

你的前端页面使用什么编码，那么你那些字符串已经被该种编码编过了，所以，尽管入库，他的机器码肯定就是那样的，不管存放在哪里，不管MYSQL指定为何种编码，他在录入数据的时候，并不会对你的数据进行转换。只要保证你的前端录入使用UTF-8，那么你读取的也是UTF-8。

为什么使用PHPMYADMIN导入总是有问题呢？

我没有研究过PHPMYADMIN的工作原理，但是他的PHP文件都是UTF-8编码的，也就是这样导入数据都是UTF-8的，你采用GB2312的PHP文件来读取，当然一堆乱。
解决办法我猜有三种：

读取的时候，使用SET NAME将其编码转换，不知道可行不，
读取后使用iconv将其转为GB2312，
不用PHPMYADMIN导入，自己写个GB2312的PHP脚本导入即可。
总之一句话，你录入的时候采用什么编码，那么你读取的时候他就是什么编码。你想把这种编码显示成另外一种编码，那么你需要使用iconv或者mbstring将其进行编码转换。

以上仅为个人实际经验，没时间研究理论。欢迎大家探讨或者有错误请指正。

本文来源于 WEB开发网 原文链接：http://cncms.com.cn/mysql/4323.htm

发表评论

网友评论

sun 作者 访客 于 2008-11-08 16:09:42 温岭市经纬流水线制造厂位于东海之滨的温岭市淋川工业区,是专业发展成为集成研究、设计、生产、销售生产线的厂家.

文化衫www.bjqingyang.com 作者 访客 于 2008-11-19 10:19:23 T恤衫   帽子   风衣   绒衣   甲克   工作服     北京促销服   北京工作服  北京职业装  北京文化衫  北京西服  北京T恤衫  北京制服  工作服  职业装  促销服  制服  西服  北京衬衫  衬衫  北京夹克  北京棉服  北京茄克  北京服装厂  北京服装公司    北京制服  职业装  北京西服  马甲  企业工作服   酒店制服   促销服    北京促销服   北京工作服  北京职业装  北京文化衫  北京西服  北京T恤衫  北京制服  工作服  职业装  促销服  制服  西服  北京衬衫  衬衫  北京夹克  北京棉服  北京茄克  北京服装厂  北京服装公司    北京促销服   北京工作服  北京职业装  北京文化衫  北京西服  北京T恤衫  北京制服  工作服  职业装  促销服  制服  西服  北京衬衫  衬衫  北京夹克  北京棉服  北京茄克  北京服装厂  北京服装公司    西服  促销服   北京促销服   服装公司  北京服装公司   服装厂  棒球帽   北京服装加工厂   西服   北京西服公司   北京工作服   工作服公司   文化衫   北京文化衫   T恤衫   北京T恤衫   广告衫   北京广告衫   制服   工程服  工作服   职业装   北京职业装     T-恤衫   北京促销服   北京工作服  北京西服   北京职业装   文化衫   北京文化衫   促销服   工作服   职业装   北京T-恤衫   衬衫   广告衫   北京广告衫   棉服   北京棉服   帽子   北京衬衫   西服   北京服装公司    T-恤衫   北京促销服   北京工作服  北京西服   北京职业装   文化衫   北京文化衫   促销服   工作服   职业装   北京T-恤衫   衬衫   广告衫   北京广告衫   棉服   北京棉服   帽子   北京衬衫   西服   北京服装公司    文化衫   北京文化衫  T恤衫   北京T恤衫   广告衫   北京广告衫

onestoptown 作者 访客 于 2008-11-20 12:25:37 shoes online buy shoes sandal shoes slippers shoes ecco shoes rockport shoes.  steve madden shoes - puma shoes -   nike shoes   nike shoes replica   replica nike shoes.  air jordan shoes   replica watches rolex   replica watch - rolex watch - fake rolex watches.  oyster rolex   rolex watches -  replica watches -  replica rolex watches - rolex replica - watches online.  oyster rolex watch - quartz watch fake - nike shoes - nike shoes replica - replica nike shoes.  air jordan shoes - replica watches rolex - replica watch - rolex watch - fake rolex watches.  oyster rolex - rolex watches - replica watches - replica rolex watches - rolex replica - watches online.  oyster rolex watch - quartz watch fake -   best replica watches  rolex watches - replica watches - replica nike shoes - jordan shoes - watches online.  oyster rolex watch - quartz shoes fake -   nike shoeses

作者 访客 于 2008-11-20 14:00:22 wrist watches jewelry watches replica replica watches fine watches casio watches watches online.  quartz watch - quartz watch fake - nike shoes   nike shoes replica   replica nike shoes.  air jordan shoes   replica watches rolex   replica watch - rolex watch - fake rolex watches.  oyster rolex   rolex watches -  replica watches -  replica rolex watches - rolex replica - watches online.  oyster rolex watch - quartz watch fake - nike shoes - nike shoes replica - replica nike shoes.  air jordan shoes - replica watches rolex - replica watch - rolex watch - fake rolex watches.  oyster rolex - rolex watches - replica watches - replica rolex watches - rolex replica - watches online.  oyster rolex watch - quartz watch fake -   best replica watches  rolex watches - replica watches - replica nike shoes - jordan shoes - watches online.  oyster rolex watch - quartz shoes fake -   best replica colth  clothes store

Replica Watches Jewelry Replica HandBags 作者 访客 于 2008-11-25 21:40:22 Replica Watches,Fake Watches,Replica Watch,Fake Watch,Wholesale Watches,Wholesale Replica Watches,Jewelry Watches,Replica Jewelry Watches.    Jewelry Wholesale, Jewelry Wholesale, Replica Handbags, Replica Handbags, Wholesale Replica Watches, Wholesale Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Fake Watches, Fake Watches, Emporio Armani Replica Watches, Emporio Armani Replica Watches, Cartier Watch, Cartier Watch, Montblanc Watch Replica, Montblanc Watch Replica, Replica Cartier Watches, Replica Cartier Watches, Rado Replica Watches, Rado Replica Watches, Movado Watches Replica, Movado Watches Replica, Patek Philippe Watches, Patek Philippe Watches, Panerai Watch Replica, Panerai Watch Replica, Chanel Replica, Chanel Replica, Fake Jacob Co Watch, Fake Jacob Co Watch, Replica Emporio Armani Watches, Replica Emporio Armani Watches, Replica Christian Dior Watches, Replica Christian Dior Watches, Replica Zenith Watches, Replica Zenith Watches, Rado Watch Replica, Rado Watch Replica, Corum Watch Replica, Corum Watch Replica, Citizen Replica Watches, Citizen Replica Watches, Replica Citizen, Replica Citizen, Replica Gucci Watch, Replica Gucci Watch, Jacques Lemans Watches, Jacques Lemans Watches, Vacheron Constantin Replica, Vacheron Constantin Replica,

Replica Watches Jewelry Replica HandBags 作者 访客 于 2008-11-26 01:12:13 Replica Watches,Fake Watches,Replica Watch,Fake Watch,Wholesale Watches,Wholesale Replica Watches,Jewelry Watches,Replica Jewelry Watches.    Replica Watches, Replica Watches, Wholesale handbags, Wholesale handbags, Fake Watches, Fake Watches, Replica Watches, Replica Watches, Replica Handbags, Replica Handbags, Replica Watches, Replica Watches, Replica Handbag, Replica Handbag, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Rado, Replica Rado, Zenith Replica Watch, Zenith Replica Watch, Franck Muller Replica Watch, Franck Muller Replica Watch, Accutron Watch Replica, Accutron Watch Replica, Replica Breitling Watch, Replica Breitling Watch, Replica Breitling Watches, Replica Breitling Watches, Fake Cartier Watch, Fake Cartier Watch, Jaeger LeCoultre Watch, Jaeger LeCoultre Watch, Replica Ebel Watch, Replica Ebel Watch, Fake Rado Watches, Fake Rado Watches, Breitling Watch Replica, Breitling Watch Replica, Fake Panerai Watch, Fake Panerai Watch, Replica Rado Watches, Replica Rado Watches, Gucci Watch, Gucci Watch, Breitling Watch, Breitling Watch, Fake Rolex ladies Watches, Fake Rolex ladies Watches, Fake Cartier Watches, Fake Cartier Watches, Gucci Watches Replica, Gucci Watches Replica, Replica Swatch Watches, Replica Swatch Watches, Omega Watch Replica, Omega Watch Replica,

replica watches 作者 访客 于 2008-12-01 10:54:20 nike air jordan -  nike sneaker -   air force one shoes -   nike womens -   nike adidas -   buy nike.  nike sb  nike shox  men's puma shoes -   timberland shoe -   large shoes -   nike football shoes.  gucci shoes  nike max  Air jordan shoes -  james sneaker -   nike shoes -   women shoes -   adidas shoes -   nike king.  nike sneakers  nike shox shoes  puma shoes -   timberland boat shoes -   big shoes -   football shoes.  gucci man shoes  nike nash        swiss watch -  sport shoe -   replica watches -   sports shoes -   designer clothes -  jewelry watches -  replica shoes -   watch repair -   buy sport shoes -   clothing store -     footwear.  nike dunk  replica bag  jewelry watch -   fashion bag -   seiko watch -   replica watch.  timex watch  prada shoes      replica rolex watches-   swiss     replica watches  clothing store  swiss     replica watch  replica     Gucci watch  replica     rolex watch  replica watches  Replica Handbags  Rolex Sports Models        nike james shoes  nike max  Areplica watches -  james sneaker -   swiss watch -   replica shoes -   clothes store

www.watchinstyle.com 作者 访客 于 2008-12-01 13:43:27 wrist watches     jewelry watches replica     replica watches     fine watches     casio watches     watches online    .  quartz watch -     quartz watch fake -     nike shoes   nike shoes replica   replica nike shoes.  air jordan shoes   replica watches rolex   replica watch - rolex     watch - fake rolex watches.  oyster rolex   rolex watches -  replica watches -  replica rolex watches -     rolex replica - watches online.  oyster rolex watch - quartz     watch fake - nike shoes -     nike shoes replica -     replica nike shoes.  air jordan shoes - replica     watches rolex - replica watch -     rolex watch - fake rolex     watches.  oyster rolex -     rolex watches -     replica watches -     replica rolex watches -     rolex replica -     watches online.  oyster rolex watch -     quartz watch fake -   best replica watches  rolex watches -     replica watches -     replica nike shoes -     jordan shoes -     watches online.  oyster rolex watch -     quartz shoes fake -   best replica colth  nike air jordan -  nike sneaker -   air force one shoes -   nike womens -   nike adidas -   buy nike.  nike sb  nike shox  men's puma shoes -   timberland shoe -   large shoes -   nike football shoes.  gucci shoes  nike max  Air jordan shoes -  james sneaker -   nike shoes -   women shoes -   adidas shoes -   nike king.  nike sneakers  nike shox shoes  puma shoes -   timberland boat shoes -   big shoes -   football shoes.  gucci man shoes  nike nash  swiss watch -  sport shoe -   replica watches -   sports shoes -   designer clothes -   best replica watches  jewelry watches -  replica shoes -   watch repair -   buy sport shoes -   clothing store -     footwear.  nike dunk  replica bag  jewelry watch -   fashion bag -   seiko watch -   replica watch.  timex watch  prada shoes

www.watchinstyle.com 作者 访客 于 2008-12-01 13:43:39 wrist watches     jewelry watches replica     replica watches     fine watches     casio watches     watches online    .  quartz watch -     quartz watch fake -     nike shoes   nike shoes replica   replica nike shoes.  air jordan shoes   replica watches rolex   replica watch - rolex     watch - fake rolex watches.  oyster rolex   rolex watches -  replica watches -  replica rolex watches -     rolex replica - watches online.  oyster rolex watch - quartz     watch fake - nike shoes -     nike shoes replica -     replica nike shoes.  air jordan shoes - replica     watches rolex - replica watch -     rolex watch - fake rolex     watches.  oyster rolex -     rolex watches -     replica watches -     replica rolex watches -     rolex replica -     watches online.  oyster rolex watch -     quartz watch fake -   best replica watches  rolex watches -     replica watches -     replica nike shoes -     jordan shoes -     watches online.  oyster rolex watch -     quartz shoes fake -   best replica colth  nike air jordan -  nike sneaker -   air force one shoes -   nike womens -   nike adidas -   buy nike.  nike sb  nike shox  men's puma shoes -   timberland shoe -   large shoes -   nike football shoes.  gucci shoes  nike max  Air jordan shoes -  james sneaker -   nike shoes -   women shoes -   adidas shoes -   nike king.  nike sneakers  nike shox shoes  puma shoes -   timberland boat shoes -   big shoes -   football shoes.  gucci man shoes  nike nash  swiss watch -  sport shoe -   replica watches -   sports shoes -   designer clothes -   best replica watches  jewelry watches -  replica shoes -   watch repair -   buy sport shoes -   clothing store -     footwear.  nike dunk  replica bag  jewelry watch -   fashion bag -   seiko watch -   replica watch.  timex watch  prada shoes

www.watchinstyle.com 作者 访客 于 2008-12-01 13:44:03 wrist watches     jewelry watches replica     replica watches     fine watches     casio watches     watches online    .  quartz watch -     quartz watch fake -     nike shoes   nike shoes replica   replica nike shoes.  air jordan shoes   replica watches rolex   replica watch - rolex     watch - fake rolex watches.  oyster rolex   rolex watches -  replica watches -  replica rolex watches -     rolex replica - watches online.  oyster rolex watch - quartz     watch fake - nike shoes -     nike shoes replica -     replica nike shoes.  air jordan shoes - replica     watches rolex - replica watch -     rolex watch - fake rolex     watches.  oyster rolex -     rolex watches -     replica watches -     replica rolex watches -     rolex replica -     watches online.  oyster rolex watch -     quartz watch fake -   best replica watches  rolex watches -     replica watches -     replica nike shoes -     jordan shoes -     watches online.  oyster rolex watch -     quartz shoes fake -   best replica colth  nike air jordan -  nike sneaker -   air force one shoes -   nike womens -   nike adidas -   buy nike.  nike sb  nike shox  men's puma shoes -   timberland shoe -   large shoes -   nike football shoes.  gucci shoes  nike max  Air jordan shoes -  james sneaker -   nike shoes -   women shoes -   adidas shoes -   nike king.  nike sneakers  nike shox shoes  puma shoes -   timberland boat shoes -   big shoes -   football shoes.  gucci man shoes  nike nash  swiss watch -  sport shoe -   replica watches -   sports shoes -   designer clothes -   best replica watches  jewelry watches -  replica shoes -   watch repair -   buy sport shoes -   clothing store -     footwear.  nike dunk  replica bag  jewelry watch -   fashion bag -   seiko watch -   replica watch.  timex watch  prada shoes

发表评论
用户	访客
标题
BBCode:
评论