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

ΪʲôMySQL²»Ö§³ÖÖÐÎİ¡£¿£¿

ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë

Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ

Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ

Ö§³ÖÖÐÎİ¡

ÒýÓÃ
Ö§³ÖÖÐÎİ¡

ÕæµÄ°¡£¿

ÒýÓÃ
ÒýÓà 5 Â¥ chenxinquan µÄ»Ø¸´:
Ö§³ÖÖÐÎİ¡

ÕæµÄ°¡£¿


¾ø¶ÔÕæµÄ


Äã¿ÉÒÔÏÂÔØ¸ö¿ÉÊÓ»¯µÄ²Ù×÷¹¤¾ßÈç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£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£

http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......

mysqlµÄÇý¶¯³ÌÐò

ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......

MYSQL ÈçºÎÐÞ¸ÄBLOBÀàÐ͵ÄÊý¾Ý?

ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿

¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......

mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿

mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿
¡¡´úÂ룿

ÒýÓÃ
mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿



½¨ÒéÌùÍêÕûinsert´úÂë¼°´íÎó´úÂ룬ÒÔ±ã·ÖÎö

ÇëÂ¥Ö÷ÌùÍêÕûµÄsql´ú ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ