What is Web±à³Ì Readers Blog?

    Web±à³Ì Readers Blog¼¯ÖÐÁËWeb×ÊÉî³ÌÐòÔ±µÄ¼¼ÇɺÍʵս¾­Ñ飬º­¸ÇÁËWeb±à³ÌµÄÈ«²¿·¶Î§: 3P(ASP, JSP, PHP) web±à³Ì¼¼Êõ£¬MySQLÊý¾Ý¿â¿ª·¢£¬·þÎñÆ÷ÍøÂ簲ȫºÍDIV+CSS²¼¾ÖµÈ£¬ÌṩһЩÓÅÐãµÄ±à³ÌÔ´Â룬ʹÄúµÄWeb±à³Ìѧϰ֮·¸ü¼Óƽ̹¡£

ä¯ÀÀģʽ: ±ê×¼ | Áбí

²ÉÓÃutf8±àÂë³¹µ×½â¾öphpÂÒÂëÎÊÌâ

Submitted by ×÷Õß: admin 2008-08-26 10:54:39

Èç¹ûÄãÊÇMySQLʹÓÃ4.1ÒÔÉϰ汾£¬²»¹ÜÊÇʲô×Ö·û¼¯£¬Ò»ÂÉʹÓÃĬÈÏ¡£²»È¥ÉèÖÃMySQL£¬Ò²²»»á²úÉúÂÒÂëµÄÀý×Ó¡££¨ÔÙ´ÎÌáʾһÏÂ×¢ÒâÒªÊÇ4.1»ò¸ü¸ß°æ±¾£©

ÄãÖ»Òª±£Ö¤ÄãµÄд×ÅINSERT SQLÓï¾äµÄPHPÎļþ±àÂëΪGB2312£¬ÄÇô£¬ÄãʹÓÃд×ÅSELECT SQLÓï¾äµÄGB2312±àÂëµÄPHPÎļþ¶ÁÈ¡³öÀ´µÄÊý¾ÝÒ²ÊÇGB2312µÄ.

ͬÀí£¬Ö»ÒªÄã²åÈëÊý¾Ý¿âµÄPHPÎļþÊÇUTF-8±àÂ룬ÄÇôÄã¼ÈëµÄ¾ÍÊÇUTF-8µÄ£¬¶ÁÈ¡³öÀ´Í¬ÑùʹÓñàÂëΪUTF-8µÄphpÀ´¶ÁÈ¡¡£

»¹Óиü¾«²ÊµÄ¡£ÒÔÉÏËäÈ»¿´ÉÏȥûÓÐÎÊÌâÁË¡£µ«ÊÇ´ò¿ªphpmyadminµÄʱºò£¬Äã¾Í»áÓÖ¿´µ½ÂÒÂëÁË£¬ÒòΪÊý¾Ý¿âµÄ×Ö·û¼¯²»Ò»¶¨ºÍÄãµÄ³ÌÐò±àÂëÒ»Ñù°¡£¬ÆäÖÐÓÐÇ£³¶µ½MySQL Á¬½ÓУ¶ÔµÈ¡£Ôõô°ì£¿ÎÒµÄÊý¾ÝÒÔºóÔõô±¸·Ý×ªÒÆ°¡£¿……²»¼±£¬ Ö»ÒªÁ½²½ÎÒÃǾ͸㶨ÂÒÂëÁË¡£

µÚÒ»£¬°Ñ²åÈëÊý¾ÝµÄphpÎļþºÍ¶ÁÈ¡Êý¾ÝµÄphpÎļþ£¬»¹ÓÐÄ£°åÎļþ£¨Èç¹ûÄãʹÓÃÁËÄ£°åÒýÇæ£©µÈÎļþ¶¼²ÉÓÃutf8µÄ±àÂë¡£

µÚ¶þ£¬ÔÚÁ´½ÓÊý¾Ý¿âºó£¬CRUDÊý¾Ý֮ǰ¼ÓÉÏÒÔÏ´úÂë:

PHP´úÂ룺
@mysql_query("SET NAMES 'utf8'");  
@mysql_query("SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary");
Èç¹ûÊDzÉÓÃadodbÔòÊÇÔÚʵÀý»¯Ò»¸ö¶ÔÏóºóÓÃÒÔÏ´úÂë:

PHP´úÂ룺
$db->execute("SET NAMES 'utf8'");  
$db->execute("SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary");

Ò»Çж¼ÊÇÔ²ÂúµÄ¡£²»½ö³ÌÐòÏÔʾûÓÐÂÒÂ룬¾ÍÊÇ¿´phpmyadminÒ²¶¼Ã»ÓÐÂÒÂëÁË¡£
ÍÆ¼öÈ«²¿²ÉÓÃutf8±àÂëµÄ·½Ê½¡£

·ÖÀà:ÍøÕ¾|PHPѧϰ | Read more ÔĶÁ (1367) ÆÀÂÛ (0)





·Ã¿Í ÆÀÂÛ





·¢±íÆÀÂÛ

êÇ¡¡³Æ (±ØÌî)

ÓÊ¡¡Ïä (±ØÌî)

Íø Õ¾

ÑéÖ¤Âë: (±ØÌî)