MYSQLÂÒÂëÔõô½â¾ö£¿
ÎÒÓõÄÊÇmysql Êý¾Ý¿â£¬ÒѾÊÔÁ˺ܶàµÄ·½·¨ÁË£¬¾ÍÊ£ÕâôÎÊÌâûÓнâ¾öÁË£¬JSPÒ³Ãæ ÊÇ gb2312£¬Á¬½ÓµÄurlÀïÒ²ÉèÖÃÁËcharacterEcoding=gb2312£»»¹ÓиöʲôÁ¬½ÓʱµÄÉèÖã¬stmt.execute("set name gb2312;");(ºÃÏñÊÇÕâÑùÆ´)£¬²åÈëµ½Êý¾Ý¿âºò¶¼ÊÇÂÒÂ룬ÔõôŪ°¡£¡£¿£¡
ÂÒÂëÎÊÌâÊǾ³£»áÓöµ½µÄ£¬±ð¼±£¬ÂýÂýµÄÕÒÔÒò¡£
1¡¢ÏÈ¿´¿´Í¨¹ýJSPÌá½»µ½servletÖеÄÊÇ·ñÊÇÂÒÂë
2¡¢ÒªÊÇ1ÖеIJ»ÊÇÂÒÂ룬¾ÍÊÇÊý¾Ý¿âµÄÎÊÌâÁË£¬ÖØÐÂ×°Ò»ÏÂmysql£¬ÔÚ°²×°¹ý³ÌÖУ¬
Óиö±àÂëÑ¡ÏѡÔñUTF-8¼´¿É¡£¡£
Java code:
stmt.execute("set names gb2312");
http://www.china56zx.com
http://blog.csdn.net/limingtianshi/archive/2008/08/21/2805958.aspx
Èç¹ûÊÇ´Ójspµ½Êý¾Ý¿âÀïÃæ³öÏÖÁËÖÐÎÄÂÒÂëÎÊÌ⣬Äã¿ÉÒÔÐÞ¸ÄÒ»ÏÂÄãmysqlµÄÅäÖÃÎļþ£¬Ò²¾ÍÊÇmy¡£iniÎļþ£¬ÖмäÓиöµØ·½ÊǶ¨Òå±àÂëµÄ£¬Çë¸ÄΪ£ºgb2312.
ÔÚ²åÈëÊý¾Ý¿âǰ´òÓ¡Ò»ÏÂÊý¾Ý¿´ÊDz»ÊÇÂÒÂë¡£
ÎÒÒѾ°ÑmysqlµÄĬÈϱàÂë¶¼¸Ä³Égb2312ÁË£¬my.iniÀïÃæµÄÄǸö±àÂëÒ²ÊÇgb2312, jspÖÐÓÃ
String resume = new String(request.getParameter("resume").getBytes("ISO8859_1"),"gb2312");ת±äÁ˱àÂë¸ñʽ£¬µ«ÊÇ»¹ÊDz»ÐУ¡
ÖÕ¼«½â¾ö°ì·¨£º°²×°Ê±£¬ÔÚ±àÂëÏÂÀ²Ëµ¥ÖÐÑ¡Ôñgb2312.ÒÔºó²»¹ÜÔõôŪ£¬¶¼²»»áÂÒÂ룡
²»ÂÒÂ룬ÇëÓÃUTF-8
ÓÃ\s²é¿´Êý¾Ý¿âÀ
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒ¿ª·¢ASP.netʱ
²åÈëÍâÎÄÂÒÂë
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
ÎÒÔÚÇåÀímysqlµÄʱºò£¬Ò»²»ÁôÉñ½«mysql(¼´dataÀïµÄmysqlÎļþ¼Ð)Êý¾Ý¿â¸øÉ¾µôÁË£¬¸ôÁ˼¸¸öСʱÎÒÖØÆôÁËmysqlÈí¼þ£¬mysql¾Í×Ô¶¯³õʼ»¯ÁËÊý¾Ý¿â£¬µ¼Ö´Óɾ³ýmysqlÎļþ¼Ð¿ªÊ¼µ½ÖØÆôÕâ¶Îʱ¼äµÄÊý¾Ý¶ªÊ§£¬ÄÇλ¸ßÊÖ°ïÏëÏë°ì ......