Ϊʲô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×Ô´øµÄC API if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0)) { AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡ Çë¸÷λ¸øÒÔÌáʾ¡£ ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É 1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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. ¿ ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
SQL code: create PROCEDURE aa(SqlCMD1 varchar(8000),SqlCMD2 varchar(8000),SqlCMD3 varchar(8000)) begin declare exit handler for sqlexception rollback; start TRANSACTION; EXECUTE SqlCMD1; EXE ......