编码乱码解决问题

《编码乱码解决问题》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Php乱码解决问题制作者：李亮(飞警)E-mail:liliang8810@163.com快速查找client（修改下面的utf8为gbk）[client]port=3306[mysql]default-character-set=gbk#SERVERSECTION#----------------------------------------------------------------------##ThefollowingoptionswillbereadbytheMySQLServer.Makesurethat#youhaveinstalledthes

2、ervercorrectly(seeabove)soitreadsthis#file.#[mysqld]#TheTCP/IPPorttheMySQLServerwilllistenonport=3306#Pathtoinstallationdirectory.Allpathsareusuallyresolvedrelativetothis.basedir="C:AppServ/MySQL"#Pathtothedatabaserootdatadir="C:AppServ/MySQL/data/"#Thedefaultcharactersetthatwillbeu

3、sedwhenanewschemaortableis#createdandnocharactersetisdefineddefault-character-set=gbkcharacter-set-server=utf8collation-server=utf8_general_ciinit_connect='SETcollation_connection=utf8_general_ci'init_connect='SETNAMESutf8'重新启动mysqlstart修改系统时间快速查找zone修改为=prc子查询：一条查询中包含另外一条查询语句称为子查询Sel

4、ect*fromstudentswhereclass=’一班’andmath=(selectmin(math)fromstudentswhereclass=’一班’)