ΪʲôMySQL²»Ö§³ÖÖÐÎİ¡£¿£¿
ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ
Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ
Ö§³ÖÖÐÎİ¡
ÕæµÄ°¡£¿
¾ø¶ÔÕæµÄ
Äã¿ÉÒÔÏÂÔØ¸ö¿ÉÊÓ»¯µÄ²Ù×÷¹¤¾ßÈçnavicat£¬ºÜºÃÓÃ
±àÂëûѡºÃ£¡Ä¬ÈÏÊÇÂÒÂëµÄ
Ö§³Ö2Â¥~
Èç¹ûĬÈϰ²×°ÊÇÀ¶¡×Ö·û¼¯µÄ»°£¬½¨±íµÄʱºò¾ÍÔÚºóÃæ¼ÓÉÏ "default charset = 'gbk/gb2312/utf8'"
ÔÚÃüÁîÐÐÀïÃæÏÔʾ±íÊý¾ÝµÄʱºòÊäÈë "set names 'gbk/gb2312/utf8'", ÔÚÁ¬½ÓÊý¾Ý¿âµÄʱºòÔÚ urlºóÃæ¼ÓÉÏ "useUnicode=true&characterEncoding=gb2312/gbk/utf8" ÕâÑùµÄ»°¾ÍÖ§³ÖÖÐÎÄÁË
q429880501 ½²µÃ¹»ÏêϸµÄ¡£
MySQLÏÖÔÚÖ»²î¶ÔÖÐÎÄÈ«ÎļìË÷µÄÖÐÎÄÖ§³ÖÁË£¬ºÃÏñÓеÚÈý·½µÄ¡£
½¨±íµÄʱºò¾ÍÔÚºóÃæ¼ÓÉÏ "engine InoDB default charset = 'gbk/gb2312/utf8'"
ÔÚÁ¬½ÓÊý¾Ý¿âµÄʱºòÔÚ urlºóÃæ¼ÓÉÏ, "useUnicode=true&setcharacterEncoding=utf8" ÕâÑùµÄ»°¾ÍÖ§³ÖÖÐÎÄÁË
¿ªÊ¼×°µÄʱºòĬÈÏÊDz»Ö§³ÖµÄ
Äã¿ÉÒÔ°²×°MySql Server Instance Configuration Wizard²å¼þ
ÔÚ×îºóÒ»²½µÄʱºòÉèÖñàÂë¸ñʽΪ:utf-8
°²×°Ê±Ñ¡Ôñgbk ¾ÍokÁË
Ö§³Ö°¡ Éè¼Æ±àÂëÓïÑÔΪ gbk »ò UTF-8
Â¥ÉϺÜÏêϸ£¬ÓÐmys
Ïà¹ØÎÊ´ð£º
ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£
http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿
¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......
mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿
¡¡´úÂ룿
ÒýÓÃ
mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿
½¨ÒéÌùÍêÕûinsert´úÂë¼°´íÎó´úÂ룬ÒÔ±ã·ÖÎö
ÇëÂ¥Ö÷ÌùÍêÕûµÄsql´ú ......