Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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²é¿´Êý¾Ý¿âÀ


Ïà¹ØÎÊ´ð£º

c#¿ØÖÆMysql ʵÏÖ×Ô¶¯É¾³ý¹¦ÄÜ - .NET¼¼Êõ / C#

Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......

Mysql ʹÓÃÎÊÌâ - Java / Web ¿ª·¢

ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ 
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£

mysqlÃüÁîÐÐģʽÏÂ: ......

MYSQL character_set_server Ôõô¸Ä

ÎÒ¿ª·¢ASP.netʱ 
²åÈëÍâÎÄÂÒÂë 
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8 
character_set_connection utf8 
character_set_database utf8 
ch ......

MySQL´íÎó - PHP / »ù´¡±à³Ì

ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿

ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ

¿ÉÒÔÓÃÈ ......

ÔõôÔÚeclipseÏÂÏòmysql²åÈë±äÁ¿°¡ - Java / JavaÏà¹Ø

String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡­¡­µ½µ×¸Ãզд°¡

Íò·Ö¸Ðл£¡

String SQL=&q ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ