Ϊʲô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
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓᣠÊý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ÉÊÇÎÒÕÒ ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡ Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7 µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡ ÔÚPHPÎļþÀï ......