Ϊʲô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Îļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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. ¿ÉÊÇÎÒÕÒ ......
´ó¼ÒºÃ: ÎÒÊǸãCµÄ, ÏÖÔÚÏëÓÃC Á¬½ÓMYSQL,µ«ÊÇÔõôҲÁ¬½Ó²»ÁË,ÎҵĴúÂëÈçÏÂ: #include <stdio.h> #include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h" ......
ÎÒÓõÄlikeÄ£ºý²éѯ£¬±ÈÈçmysqlµÄnameÖÐÓС°csdnÂÛ̳ϵͳ¡±Õ⼸¸ö×Ö£¬ÈçºÎÔÚ <input>Öвéѯ¡°csdn ϵͳ¡±Ò²ÄܳöÀ´Õâ¸ö¡°csdnÂÛ̳ϵͳ¡±£¬ÎÒÏÖÔÚÊDz顰csdn¡±»òÕß¡°ÏµÍ³¡±¶¼¿ÉÒÔ¡£Ð»Ð»¸÷λÁË£¡²»ÖªµÀÎÒÕâô±í´ï ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......