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»ÊÇÂÒÂë¡£ÒýÓà http://blog.csdn.net/limingtianshi/archive/2008/08/21/2805958.aspx ÎÒÒѾ°ÑmysqlµÄĬÈϱàÂë¶¼¸Ä³Égb2312ÁË£¬my.iniÀïÃæµÄÄǸö±àÂëÒ²ÊÇgb2312, jspÖÐÓà String resume = new String(request.getParameter("resume").getBytes("ISO8859_1"),"gb2312");ת±äÁ˱àÂë¸ñʽ£¬µ«ÊÇ»¹ÊDz»ÐУ¡ ÖÕ¼«½â¾ö°ì·¨£º°²×°Ê±£¬ÔÚ±àÂëÏÂÀ²Ëµ¥ÖÐÑ¡Ôñgb2312.ÒÔºó²»¹ÜÔõôŪ£¬¶¼²»»áÂÒÂ룡 ²»ÂÒÂ룬ÇëÓÃUTF-8 ÓÃ\s²é¿´Êý¾Ý¿âÀ
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒ¿ª·¢ASP.netʱ ²åÈëÍâÎÄÂÒÂë SHOW VARIABLES LIKE 'character%'; Õâ¸öʱºò character_set_client utf8 character_set_connection utf8 character_set_database utf8 ch ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡ mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿ ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ ¿ÉÒÔÓÃÈ ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡ Íò·Ö¸Ðл£¡ String SQL=&q ......