Mysql乱码问题.docx
- 文档编号:18657577
- 上传时间:2023-08-24
- 格式:DOCX
- 页数:28
- 大小:33.73KB
Mysql乱码问题.docx
《Mysql乱码问题.docx》由会员分享,可在线阅读,更多相关《Mysql乱码问题.docx(28页珍藏版)》请在冰点文库上搜索。
Mysql乱码问题
MysqlÂÒÂëÎÊÌâ
2006-04-28adminµã»÷:
1423
MysqlÂÒÂëÎÊÌâ
¸öÈ˽¨Òé,Êý¾Ý¿â×Ö·û¼¯¾¡Á¿Ê¹ÓÃutf8(utf-8),ÒÔʹÄãµÄÊý¾ÝÄܺÜ˳ÀûµÄʵÏÖǨÒÆ,ÒòΪutf8×Ö·û¼¯ÊÇÄ¿Ç°×îÊʺÏÓÚʵÏÖ¶àÖÖ²»Í¬×Ö·û¼¯Ö®¼äµÄת»»µÄ×Ö·û¼¯,¾¡¹ÜÄãÔÚÃüÁîÐй¤¾ßÉÏÎÞ·¨ÕýÈ·²é¿´Êý¾Ý¿âÖеÄÄÚÈÝ,ÎÒÒÀȻǿÁÒ½¨ÒéʹÓÃutf8×÷ΪĬÈÏ×Ö·û¼¯.
½ÓÏÂÀ´ÊÇÍêÕûµÄÒ»¸öÀý×Ó£º
1.´´½¨Êý¾Ý¿â±í
mysql>CREATEDATABASEIFNOTEXISTSmy_dbdefaultcharsetutf8COLLATEutf8_general_ci;
#×¢ÒâºóÃæÕâ¾ä»°"COLLATEutf8_general_ci",´óÖÂÒâ˼ÊÇÔÚÅÅÐòʱ¸ù¾Ýutf8±äÂë¸ñʽÀ´ÅÅÐò
#ÄÇôÔÚÕâ¸öÊý¾Ý¿âÏ´´½¨µÄËùÓÐÊý¾Ý±íµÄĬÈÏ×Ö·û¼¯¶¼»áÊÇutf8ÁË
mysql>createtablemy_table(namevarchar(20)notnulldefault'')type=myisamdefaultcharsetutf8;
#Õâ¾ä»°¾ÍÊÇ´´½¨Ò»¸ö±íÁË,Öƶ¨Ä¬ÈÏ×Ö·û¼¯Îªutf8
2.дÊý¾Ý
Àý×Ó1ÊÇͨ¹ýphpÖ±½Ó²åÈëÊý¾Ý:
a.php
php
mysql_connect('localhost','user','password');
mysql_select_db('my_db');
//Çë×¢Òâ,Õâ²½ºÜ¹Ø¼ü,Èç¹ûûÓÐÕâ²½,ËùÓеÄÊý¾Ý¶Áд¶¼»á²»ÕýÈ·µÄ
//ËüµÄ×÷ÓÃÊÇÉèÖñ¾´ÎÊý¾Ý¿âÁª½Ó¹ý³ÌÖÐ,Êý¾Ý´«ÊäµÄĬÈÏ×Ö·û¼¯
mysql_query("setnamesutf8;");
//±ØÐ뽫gb2312(±¾µØ±àÂë)ת»»³Éutf-8,Ò²¿ÉÒÔʹÓÃiconv()º¯Êý
mysql_query(mb_convet_encoding("insertintomy_tablevalues('²âÊÔ');","utf-8","gb2312"));
?
>
Àý×ÓÊÇͨ¹ýÒ³ÃæÌá½»²åÈëÊý¾Ý2:
b.php
php
//Êä³ö±¾Ò³±àÂëΪutf-8
header("content-type:
text/html;charset=utf-8");
mysql_connect('localhost','user','password');
mysql_select_db('my_db');
if(isset($_REQUEST['name'))
{
//ÓÉÓÚÉÏÃæÒѾָ¶¨±¾Ò³×Ö·û¼¯Îªutf-8ÁË,Òò´ËÎÞÐèת»»±àÂë
mysql_query(sprintf("insertintomy_tablevalues('%s');",$_REQUEST['name']));
}
$q=mysql_query("select*frommy_table");
while($r=mysql_fetch_row($q))
{
print_r($r);
}
?
>
×Ô´Ë,ʹÓÃutf8×Ö·û¼¯µÄÍêÕûµÄÀý×Ó½áÊøÁË.
Èç¹ûÄãÏëʹÓÃgb2312±àÂë,ÄÇô½¨ÒéÄãʹÓÃlatin1×÷ΪÊý¾Ý±íµÄĬÈÏ×Ö·û¼¯,ÕâÑù¾ÍÄÜÖ±½ÓÓÃÖÐÎÄÔÚÃüÁîÐй¤¾ßÖвåÈëÊý¾Ý,²¢ÇÒ¿ÉÒÔÖ±½ÓÏÔʾ³öÀ´.¶ø²»ÒªÊ¹ÓÃgb2312»òÕßgbkµÈ×Ö·û¼¯,Èç¹ûµ£ÐIJéѯÅÅÐòµÈÎÊÌâ,¿ÉÒÔʹÓÃbinaryÊôÐÔÔ¼Êø,ÀýÈç:
createtablemy_table(namevarchar(20)binarynotnulldefault'')type=myisamdefaultcharsetlatin1;
¸½£º¾ÉÊý¾ÝÉý¼¶°ì·¨
ÒÔÔÀ´µÄ×Ö·û¼¯Îªlatin1ΪÀý£¬Éý¼¶³ÉΪutf8µÄ×Ö·û¼¯¡£ÔÀ´µÄ±í:
old_table(defaultcharset=latin1)£¬ÐÂ±í£ºnew_table(defaultcharset=utf8)¡£
µÚÒ»²½£ºµ¼³ö¾ÉÊý¾Ý
mysqldump--default-character-set=latin1-hlocalhost-uroot-Bmy_db--tablesold_table>old.sql
µÚ¶þ²½£º×ª»»±àÂë
iconv-tutf-8-fgb2312-cold.sql>new.sql
ÔÚÕâÀ¼Ù¶¨ÔÀ´µÄÊý¾ÝĬÈÏÊÇgb2312±àÂë¡£
µÚÈý²½£ºµ¼Èë
ÐÞ¸Äold.sql£¬Ôö¼ÓÒ»ÌõsqlÓï¾ä£º"SETNAMESutf8;"£¬±£´æ¡£
mysql-hlocalhost-urootmy_db ´ó¹¦¸æ³É£¡£¡ =============================== Mysql×Ô4.1ÒÔºó£¬Ôö¼ÓÁ˶Ô×Ö·û¼¯µÄÖ§³Ö¡£±ÊÕß֮ǰ¶ÔMysql±È½ÏÁ˽⣬¸Õ½Ó´¥4.1ʱ£¬¸Ð¾õMysqlÓеã¶à´ËÒ»¾Ù£¬µ«ºóÀ´Ï¸Ïë·¢ÏÖ£¬¶Ô×Ö·û¼¯µÄÖ§³Ö£¬ËäÈ»¶Ô¿ª·¢ÕßÀ´Ëµ£¬»áÂ鷳һЩ£¬µ«²»¿É·ñÈÏ£¬ÊÇÒ»ÖÖ½ø²½¡£¶Ô×Ö·û¼¯µÄÖ§³Ö£¬²»½ö¸ü¼ÓÖ§³Ö¶àÓïÑÔ£¬¶øÇÒ£¬Ò²·½±ãÒÆÖ²¡£ ¸Õ¿ªÊ¼Ê¹ÓÃMysql4.1£¬Äã¿ÉÄܸоõÓе㲻ÊÊ£¬ÏÂÃ棬¼òµ¥²ûÊöһϱÊÕ߶ÔMysql4.1×Ö·û¼¯µÄÀí½â£¬ÔÙ½²ÊöÈçºÎPHPÈçºÎÊÊÓ¦MysqlµÄÕâÖֱ仯£¬Ï£Íû´ó¼Ò¿´¹ýÕâÎÄÕºó£¬Äܹ»ÓÐËùÊÕ»ñ¡£ Èç¹ûÄã¶Ô¼ÆËã»ú»ù´¡ÖªÊ¶²»Á˽⣬ÇëÖ±½ÓÔĶÁ¡°½áÂÛƪ¡± Ò»£®ÔÀíƪ MysqlµÄ×Ö·û¼¯ÀïÓÐÁ½¸ö¸ÅÄһ¸öÊÇ¡°Characterset£¨×Ö·û¼¯£©¡±£¬ÁíÒ»¸öÊÇ¡°Collations¡±¡£ 1.Collations Collations·³ÉÖÐÎÄÊÇ¡°Ð£Ñ顱£¬ÔÚÍøÒ³¿ª·¢µÄ¹ý³ÌÖУ¬Õâ¸ö´Ê»ã£¬Ö»ÔÚMysqlÀïʹÓã¬Ö÷Òª×÷ÓÃÊÇÖ¸µ¼Mysql¶Ô×Ö·ûµÄ±È½Ï£¬±ÈÈ磬ASCII×Ö·û¼¯ÀCollations¹æ¶¨ÁËaСÓÚb£¬aµÈÓÚa£¬ÒÔ¼°aÊÇ·ñµÈÓÚAÖ®ÀàµÄ¡£Í¨³££¬´ó¼Ò»ù±¾¿ÉÒÔºöÂÔCollationsµÄ´æÔÚ£¬ÒòΪÿ¸ö×Ö·û¼¯¶¼ÓÐÒ»¸öĬÈϵÄCollations£¬Í¨³££¬Ê¹ÓÃĬÈϵÄCollations¾Í¿ÉÒÔÁË¡£ 2.×Ö·û¼¯ ÓëÕâ¶Ô±ÈµÄÊÇ£¬×Ö·û¼¯ÊǸö¸ü¹ãµÄ¸ÅÄ¼´Ê¹ÊÇWindowsÏÂÆÕͨµÄÎı¾Îļþ£¬Ò²Éø¼°µ½×Ö·û¼¯µÄÎÊÌâ¡£²»Í¬µÄ×Ö·û¼¯£¬¹æ¶¨Á˲»Í¬µÄ×Ö·ûµÄ±àÂ뷽ʽ¡£Ò»¸öcharacterset(×Ö·û¼¯)ÊÇÒ»×é·ûºÅºÍ±àÂ룬±ÈÈ磬ASCII×Ö·û¼¯£¬°üÀ¨µÄ×Ö·ûÓУºÊý×Ö£¬´óСд×Öĸ£¬·ÖºÅ¡¢»»ÐÐÖ®ÀàµÄ·ûºÅ£¬±àÂ뷽ʽÊÇÓÃÒ»¸ö7bit±íʾһ¸ö×Ö·û£¨AµÄ±àÂëÊÇ65£¬bµÄ±àÂëÊÇ98£©¡£ASCIIÖ»¹æ¶¨ÁËÓ¢ÎÄ×ÖĸµÄ±àÂ룬·ÇÓ¢ÎÄÓïÑÔ²»ÄÜÓÃASCII±àÂë±íʾ£¬Îª´Ë£¬²»Í¬µÄ¹ú¼Ò£¬¶¼Îª×Ô¼ºµÄÓïÑÔ×öÁ˱àÂ룬±ÈÈ磬ÎÒÃǹú¼Ò£¬¾ÍÓÐGB2312±àÂë¡£µ«Ã¿¸ö¹ú¼ÒÖ®¼äµÄ±àÂ벻ͬ£¬Ò²´æÔÚ×ÅһЩ¿çƽ̨µÄÎÊÌ⣬Ϊ´Ë£¬Ò»Ð©¹ú¼Ê»¯±ê×¼×éÖ¯£¬¾ÍÖƶ¨ÁËһЩ¹ú¼ÊͨÓõıàÂ룬×î³£ÓõľÍÊÇUTF8ÁË¡£ASCIIÖ»¶ÔÓ¢ÎÄ·ûºÅºÍÓ¢ÎÄ×Öĸ×öÁ˱àÂ룬GB2312¶ÔÓ¢ÎÄ·ûºÅ£¬Ó¢ÎÄ×Öĸ£¬ºº×Ö×öÁ˱àÂ룬UTF8¶ÔÊÀ½çÉÏËùÓеÄÓïÑÔÎÄ×Ö×öÁ˱àÂ룬ËùÒÔ£¬GB1212µÄ×Ö·û°üº¬ÁËASCII×Ö·û£¬UTF8°üº¬ÁËGB2312×Ö·û¡£Óɴ˿ɼû£¬UTF8ÊÇËùº¬×î¹ã×Ö·ûµÄ×Ö·û¼¯£¬ËùÒÔ£¬ÔÚһЩ¶àÓïÑÔµÄWEBϵͳÖУ¬Ò»°ãÓÃUTF8×Ö·û¼¯£¨PHPMyAdminʹÓÃUTF8±àÂ룩¡£ ÈκÎÎı¾µÄ´æ´¢£¬¶¼Éø¼°µ½×Ö·û¼¯µÄ¸ÅÄî¡£°üÀ¨Êý¾Ý¿â£¬Ò²°üÀ¨ÆÕͨµÄÎı¾Îļþ¡£ Ö÷ÒªÊõÓ ×Ö·û£ººº×Ö£¬Ó¢ÎÄ×Öĸ£¬±êµã·ûºÅ£¬À¶¡Îĵȵȡ£ ±àÂ룺½«×Ö·ûת»»³É¼ÆËã»ú´æ´¢µÄ¸ñʽ£¬±ÈÈ磬AÓÃ65±íʾ¡£ ×Ö·û¼¯£ºÒ»×é×Ö·ûÒÔ¼°¶ÔÓ¦µÄ±àÂ뷽ʽ¡£ a.MysqlµÄ×Ö·û¼¯ MysqlÄ¿Ç°Ö§³Ö¶à×Ö·û¼¯£¬²¢ÇÒ£¬Ö§³ÖÔÚ²»Í¬µÄ×Ö·û¼¯Ö®¼äת»»£¨±ãÓÚÒÆÖ²ºÍÖ§³Ö¶àÓïÑÔ£©¡£ Mysql¿ÉÒÔÉèÖ÷þÎñÆ÷¼¶×Ö·û¼¯¡¢Êý¾Ý¿â¼¶×Ö·û¼¯¡¢Êý¾Ý±í¼¶×Ö·û¼¯¡¢±íÁеÄ×Ö·û¼¯£¬Êµ¼ÊÉÏ£¬×îÖÕʹÓÃ×Ö·û¼¯µÄµØ·½ÊÇ´æ´¢×Ö·ûµÄÁУ¬±ÈÈ磬ÄãÉèÖÃtable1ÖÐcol1ÁÐÊÇ×Ö·ûÀàÐÍ£¬col1²ÅÓõ½ÁË×Ö·û¼¯£¬Èç¹ûtable1±íµÄcol2ÁÐÊÇintÀàÐÍ£¬col2²»Ê¹ÓÃ×Ö·û¼¯µÄ¸ÅÄî¡£ ·þÎñÆ÷¼¶×Ö·û¼¯¡¢Êý¾Ý¿â¼¶×Ö·û¼¯¡¢Êý¾Ý±í¼¶×Ö·û¼¯¶¼ÊÇΪÁеÄ×Ö·û¼¯×öĬÈÏÑ¡ÏîµÄ¡£ MysqlÒ»¶¨ÓÐÒ»¸ö×Ö·û¼¯£¬¿ÉÒÔͨ¹ýÆô¶¯Ê±¼Ó²ÎÊýÖ¸¶¨£¬Ò²¿ÉÒÔ±àÒëʱָ¶¨£¬Ò²¿ÉÒÔÔÚÅäÖÃÎļþÀïÖ¸¶¨¡£Mysql·þÎñÆ÷×Ö·û¼¯£¬Ö»ÊÇ×öΪÊý¾Ý¿â¼¶µÄĬÈÏÖµ¡£´´½¨Êý¾Ý¿âʱ£¬Äã¿ÉÒÔÖ¸¶¨×Ö·û¼¯£¬Èç¹ûûָ¶¨£¬¾ÍʹÓ÷þÎñÆ÷µÄ×Ö·û¼¯¡£Í¬Àí£¬´´½¨±íʱ£¬Äã¿ÉÒÔÖ¸¶¨±í¼¶µÄ×Ö·û¼¯£¬Èç¹ûûָ¶¨£¬Ê¹ÓÃÊý¾Ý¿âµÄ×Ö·û¼¯×öΪ±íµÄ×Ö·û¼¯¡£´´½¨ÁÐʱ£¬Äã¿ÉÒÔÖ¸¶¨Ä³ÁеÄ×Ö·û¼¯£¬Èç¹ûûָ¶¨£¬¾ÍʹÓñíµÄ×Ö·û¼¯¡£ ͨ³£Çé¿öÏ£¬ÄúÖ»ÐèÉèÖ÷þÎñÆ÷¼¶µÄ×Ö·û¼¯£¬ÆäËüµÄÊý¾Ý¿â¼¶£¬±í¼¶£¬ÒÔ¼°Á춵Ä×Ö·û¼¯£¬¶¼¼Ì³Ð×Ô·þÎñÆ÷¼¶×Ö·û¼¯¡£ ÓÉÓÚUTF8ÊÇ×î¹ãµÄ×Ö·û¼¯£¬ËùÒÔ£¬Ò»°ãÇé¿öÏ£¬ÎÒÃÇÉèÖÃMysql·þÎñÆ÷¼¶µÄ×Ö·û¼¯ÎªUTF8£¡ b.ÆÕͨÎı¾µÄ×Ö·û¼¯ÎÊÌâ ÈκÎÎı¾µÄ´æ´¢£¬¶¼´æÔÚ×Å×Ö·û¼¯µÄÎÊÌ⣬ÆÕͨÎı¾ÎļþÒ²²»ÀýÍâ¡£ Windows2000+µÄϵͳÖУ¬´ò¿ª¼Çʱ¾£¬¡°±£´æΪ¡¡±¶Ô»°¿ò£¬¾ÍÓÐÒ»¸öÑ¡Ï¿ÉÒÔÈÃÄãÑ¡Ôñ´æ´¢Îı¾µÄ±àÂ뷽ʽ¡£ ͨ³£Çé¿öÏ£¬´ó¼Ò¶¼Ê¹ÓÃWindows2000+µÄϵͳ£¬¶¼Ê¹ÓÃĬÈϵıàÂ룬ËùÒÔ£¬²»»áÅöµ½×Ö·û¼¯µÄÎÊÌâ¡£ WindowsÏ£¬±£´æÎı¾Îļþʱ£¬¿ÉÒÔÑ¡Ôñ±àÂ뷽ʽ£¬µ«´ò¿ªÎı¾Îļþʱ£¬¶¼ÊÇ×Ô¶¯ÅжϱàÂ뷽ʽµÄ¡£ÍøÉÏÓÐÒ»¸öÓÃWindows2000+µÄ¼Çʱ¾ÍæÒƶ¯£¬ÁªÍ¨µÄЦ»°£¬´ó¼Ò¿ÉÒÔËÑËÑ£¬¾ÍÊÇÒòΪWindowsÔÚ´ò¿ªÎı¾Îļþʱ£¬±àÂëÅжϴíÎóÒýÆðµÄÎÊÌâ¡£ ÒòΪ×Ô¶¯ÅжϱàÂëÓÐʱ»á´íÎó£¬ËùÒÔ£¬ÓеÄÎı¾Îļþ£¬¹æ¶¨ÁËÈçºÎʶ±ð×ÔÉíËùʹÓõıàÂë¡£HTMLÎļþ¾ÍÊÇÒ»¸öÕâÑùµÄÀý×Ó¡£ HTMLÊÇÎı¾Îļþ¡£´æ´¢HTMLÎļþµÄʱºò£¬ÐèҪʹÓÃÒ»¸ö±àÂ룬²¢ÇÒ£¬ÔÚHTMLÎļþÀҲʹÓÃHTMLÓï·¨£¬Ö¸¶¨Á˸ÃÎļþËùʹÓõıàÂ루±ÈÈ磩¡£Èç¹ûHTMLÎļþûÓÐÖ¸¶¨±àÂ룬Ôòä¯ÀÀÆ÷×Ô¶¯Ê¶±ðÎļþµÄ±àÂë¡£Èç¹ûHTMLÖ¸¶¨Á˱àÂ룬Ôòä¯ÀÀÆ÷ʹÓÃHTMLÖ¸¶¨µÄ±àÂë¡£ ͨ³£Çé¿öÏ£¬HTMLÎļþÖ¸¶¨µÄcharsetºÍHTMLÎļþ×ÔÉíµÄ±àÂëÊÇÒ»Öµģ¬µ«Ò²Óв»Ò»ÖµÄÇé¿ö£¬Èç¹û²»Ò»Ö£¬¾Í»áµ¼ÖÂÍøÒ³ÂÒÂë(´Ë´¦ÂÒÂ룬ֻºÍÎı¾ÎļþÓйأ¬ºÍÊý¾Ý¿âÎ޹ء£)ʹÓÃרÃŵÄÍøÒ³±à¼¹¤¾ß£¨±ÈÈçDreamwave£©£¬»á×Ô¶¯¸ù¾ÝÍøÒ³ÖеÄcharsetÖµÀ´±àÂëÎļþ¡£ c.php+mysqlµÄ×Ö·û¼¯ÎÊÌâ PHP×îÖÕÉú³ÉµÄÊÇÎı¾Îļþ£¬µ«ËûҪȡÊý¾Ý¿âÀïµÄÎı¾£¬»ò½«Îı¾´æ½øÊý¾Ý¿â¡£ ÓÉÓÚMysqlÖ§³Ö¶à×Ö·û¼¯£¬Ä¬ÈÏÇé¿öÏ£¬Mysql²»ÖªµÀPHP·¢¸øËûµÄÊÇʲô±àÂëµÄ×Ö·û£¬ËùÒÔ£¬MysqlÒªÇó¿Í»§¶Ë£¨PHP£©¸æËßËû´æÈ¡µÄ×Ö·û¼¯ÊÇʲô¡£ PHPͨ¹ýÉèÖÃcharacter_set_client£¬¸æËßMysql£¬PHP´æ½øÊý¾Ý¿âµÄÊÇʲô±àÂ뷽ʽ¡£ PHPͨ¹ýÉèÖÃcharacter_set_results£¬¸æËßMysql£¬PHPÐèҪȡʲôÑù±àÂëµÄÊý¾Ý¡£ PHPͨ¹ýÉèÖÃcharacter_set_connection£¬¸æËßMysql£¬PHP²éѯÖеÄÎı¾£¬Ê¹ÓÃʲô±àÂë¡£ MYSQLʹÓÃÉèÖõıàÂ뷽ʽ´æ´¢Îı¾¡£ ¼ÙÉèMysqlʹÓÃsetserverÀ´´æ´¢Îı¾£¬PHPµÄcharacter_set_clientÊÇsetclient£¬PHPµÄcharacter_set_resultsÊÇsetresult¡£ÄÇô£¬Mysql½«PHP·¢À´µÄÎı¾£¬´Ósetclient±àÂ뷽ʽ£¬×ª»»³Ésetserver±àÂ뷽ʽ£¬ÔÙ´æÈëÊý¾Ý¿â£¬Èç¹ûPHPÈ¡Îı¾£¬Mysql½«Îı¾´Ósetserverת»»³Ésetresult£¬ÔÙ·¢Ë͸øPHP¡£ PHPÎļþ£¨×îÖÕÉú³ÉµÄHTMLÎļþ£©±¾ÉíÓиö±àÂ룬Èç¹ûMysql´«¹ýÀ´µÄ±àÂ룬ÓëPHPÎļþ×ÔÉíµÄ±àÂ벻ͬ£¬ÄÇô£¬Õû¸öÍøÒ³£¬±ØÈ»ÂÒÂë¡£ËùÒÔ£¬PHPÒ»°ã½«×Ô¼ºµÄ±àÂ뷽ʽ£¬¸æËßMysql¡£ Òª±£Ö¤²»ÂÒÂ룬¾Í±ØÐ뽫Èý¸ö±àÂëͳһ£ºÒ»ÊÇÍøÒ³×ÔÉíµÄ±àÂ룬¶þÊÇHTMLÀïÖ¸¶¨µÄ±àÂ룬ÈýÊÇPHP¸æËßMysqlµÄ±àÂë(°üÀ¨character_set_clientºÍcharacter_set_results)¡£ µÚÒ»ºÍµÚ¶þ¸ö±àÂ룬Èç¹ûʹÓÃDWÖ®ÀàµÄ±à¼Æ÷дµÄÍøÒ³£¬Í¨³£ÊÇÒ»Öµģ¬µ«ÓüÇʱ¾Ð´µÄÍøÒ³£¬ÓпÉÄܲ»Ò»Ö¡£ µÚÈý¸ö±àÂ룬ÐèÒªÊÖ¹¤Í¨ÖªMysql¡£Õâ²½¿ÉÒÔͨ¹ýÔÚPHPÀïʹÓÃmysql_query(¡°setnamescharacterX¡±)À´ÊµÏÖ¡£ d.×Ö·û¼¯µÄת»»ÎÊÌâ Èç¹ûС×Ö¼¯×ª»»³É´ó×Ö·û¼¯£¬²»»á¶ªÊ§Êý¾Ý£¬µ«´ó×Ö¼¯£¬×ª»»³ÉС×Ö¼¯£¬¿ÉÄܻᶪʧÊý¾Ý¡£ ±ÈÈ磬UTF8ÀïÓеÄ×Ö·û£¬GB2312²»Ò»¶¨ÓУ¬ËùÒÔ£¬´ÓUTF8ת»»µ½GB2312¿ÉÄܻᶪʧһЩ×Ö·û¡£ µ«ÓÐÖÖÇé¿öÀýÍ⣬ÏÈ´ÓGB2312ת³ÉUTF8£¬ÔÙ´ÓUTF8ת³ÉGB2312£¬ÕâÖÖÇé¿öÊDz»»á¶ªÊý¾ÝµÄ£¬ÒòΪ£¬¸Õ¿ªÊ¼×ª»»µÄÎı¾£¬¶¼ÊÇGB2312ÀïµÄ×Ö·û£¬ËùÒÔ£¬Õû¸ö¹ý³Ì¶¼ÊÇGB2312µÄ×Ö·ûÔÚת»»£¬²»»á¶ªÊ§¡£ ÕýÒòΪUTF8ÄÜÈÝÄÉÊÀ½çÉϵÄËùÓÐ×Ö·û£¬ËùÒÔ£¬Êý¾Ý¿âÒ»°ãʹÓÃUTF8±àÂë¡£ÕâʹµÃ£¬ÈκÎ×Ö·û¶¼¿ÉÒÔ´æ½øUTF8±àÂëµÄÊý¾Ý¿â¡£ e.PHPMyAdminÂÒÂëµÄÎÊÌâ PHPMyAdminÖ§³Ö¶à¹úÓïÑÔ£¬Õâ¾Í±Ø¶¨ÒªÇóHTMLÒ³ÃæʹÓÃUTF8±àÂë¡£ HTMLÒ³ÃæʹÓÃUTF8±àÂ룬Õâ¾Í±Ø¶¨ÒªÇóPHPMyAdminÁ¬½ÓMysqlʱ£¬character_set_clientºÍcharacter_set_resultsʹÓÃUTF8±àÂë¡£ µ±Ç°Çé¿öÏ£¬PHPÁ¬½ÓMysqlÖ»ÄÜÊÇʹÓÃsetnames(»òÆäËü¼¸¸öÓï¾ä)À´Í¨ÖªMysqlµÄ±àÂ뷽ʽ£¬Èç¹ûûÓÐÏÔʽµÄÉùÃ÷±àÂ뷽ʽ£¬¶¼½«Ê¹ÓÃlatin1±àÂë¡£Ò»°ãµÄ³ÌÐò£¬¶¼Ã»ÓÐÏÔʽÉùÃ÷character_set_client±äÁ¿£¬ËùÒÔ£¬¶¼Êǽ«gb2312Îı¾£¬°´latin1±àÂ뷽ʽ´æÔÚÊý¾Ý¿â£¬PHPMyAdminÔÙÓÃutf8¸ñʽ¶ÁÈ¡£¬¿Ï¶¨ÊÇÂÒÂëµÄ¡£ Èç¹ûPHP³ÌÐò°´ÕýÈ·µÄ±àÂë´æÈëÊý¾Ý¿â£¬¿Ï¶¨ÊÇûÓÐÎÊÌâµÄ¡£ËùÒÔ£¬ÐèÒªÐ޸ĵIJ»ÊÇPHPMyAdmin.£¨ËäÈ»ÓÐʱÐÞ¸ÄPHPMyAdmin¿ÉÒÔ½â¾öÂÒÂëÎÊÌ⣬µ«Õâ²»ÊÇÎÊÌâµÄ¸ù±¾£© ¶þ£®×ܽáƪ ÉÏÃæµÄ½²µÃÓеãÂÒ£¬×ܽáһϣº 1.Êý¾Ý¿â¾¡Á¿Ê¹ÓÃutf8´æ´¢£¨ÐÞ¸Ä/etc/f£¬ÔÚ[mysqld]¶Î¼ÓÉÏdefault-character-set=utf8£© (ÒÑÓеÄÊý¾Ý¿â£¬ÏÈת³ÉUTF8¸ñʽ) 2.PHP³ÌÐòÔÚ²éѯÊý¾Ý¿â֮ǰ£¬Ö´ÐÐmysql_query(¡°setnamesxxxx¡±);ÆäÖÐxxxxÊÇÄãÍøÒ³µÄ±àÂë(charset=xxxx)£¬Èç¹ûÍøÒ³ÖÐcharset=utf8£¬Ôòxxxx=utf8£¬Èç¹ûÍøÒ³ÖÐcharset=gb2312£¬Ôòxxxx=gb2312£¬Èç¹ûÍøÒ³ÖеÄcharset=ipaddr£¬Ôòxxxx=ipaddr(¿ª¸öÍæЦ£¬Ã»Õâ±àÂë) ¼¸ºõËùÓÐWEB³ÌÐò£¬¶¼ÓÐÒ»¶ÎÁ¬½ÓÊý¾Ý¿âµÄ¹«¹²´úÂ룬·ÅÔÚÒ»¸öÎļþÀÔÚÕâÎļþÀ¼ÓÈëmysql_query(¡°setnames¡±)¾Í¿ÉÒÔÁË¡£ 3.PHPMyAdmin²»ÐèÒª×ö¸Ä¶¯¡£ 4.ÐèҪעÒâµÄÊÇ£¬Îª±£Ö¤Íøҳʵ¼Ê±àÂë(Windows±£´æ¶Ô»°¿òÀïµÄ±àÂë)ºÍËûÉùÃ÷µÄ±àÂë(charset=? )ÊÇÒ»Öµģ¬ÇëÓÃDWÖ®ÀàµÄ¹¤¾ß×öÍøÒ³¡£ дµÃÓеã²Ö´Ù£¬Ï£Íû´ó¼ÒÖ¸ÕýºÍ²¹³ä¡£ ======================================== µÚһƪ£ºAMySQL4.1Story ÏÂÃæҪдµÄÊÇһƪ·Ç³£ÎÞÁĵĶ«Î÷£¬³ä³âÁË´óÁ¿¸÷ʽ¸÷ÑùµÄ±àÂ롢ת»»¡¢¿Í»§¶Ë¡¢·þÎñÆ÷¶Ë¡¢Á¬½Ó¡¡ßÀ£¬ÎÒ×Ô¼º¶¼²»Ô¸ÒâÈ¥¿´Ëü£¬µ«ÏëÒ»Ï룬дÏÂÀ´»¹ÊÇÓеãÒ
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Mysql 乱码 问题