mysql´æ´¢ÖÐÎÄÏÔʾÎÊÌâ
ʹÓÃVCÁ¬½Ómysql5.0£¬mysql×Ö·û¼¯Ñ¡Ôñuft8£¬VCʹÓÃunicode ·¢ÏÖ£¬vcÖÐÏÔʾµÄÊý¾Ý¿âµÄÊý¾ÝÈ«²¿³ÉΪÂÒÂ룬²»¹ÜÊÇÖÐÎÄ»¹ÊÇÓ¢ÎÄ ÇëÎÊÕâÊÇʲôÔÒò£¿ ËäÈ»ÎÒʹÓÃgbkºÍ·Çunicode£¬Äܹ»ÕýÇеÄÏÔʾÖÐÎÄ£¬ÖÐÎÄÊý¾Ý²åÈëÒ²Õý³£ µ«ÊÇÎÒÏëʹÓÃunicode£¬ËÄܸæËßÎÒʹÓÃmysqlʹÓÃunicode×Ö·û¼¯£¬³ÌÐòʹÓÃunicode±àÂëÄܹ»ÕýÈ·ÏÔʾ×Ö·û? ²»Ê¤¸Ð¼¤!
Ã²ËÆÎÞЧ¹û£¬ÍøÉϾÓÈ»ÕÒ²»µ½visual studioÁ¬½Ómysql³öÏÖÂÒÂëµÄÀý×ÓÒýÓÃ Ã²ËÆÎÞЧ¹û ÄãÊÇÔÚÄÄ¼ÓµÄ set names ... °´ÕÕһ¥Ìù×ÓÖеķ½·¨£¬ÌṩÄãµÄ×Ö·û¼¯Ïà¹ØÐÅÏ¢¡£ VC6.0ÖÐÒѾ½â¾ö£¬Ê¹ÓÃutf8ʱÔÚ´úÂëÖн«utf8ת»»Îªgbk±àÂë¾ÍÄÜÕýÈ·ÏÔʾÖÐÎÄ µ«ÊÇÎÒÓÖ·¢ÏÖÁËÒ»¸ö¹îÒìµÄÏÖÏó ÎÒʹÓÃvisual studio 2005Á¬½Ómysql£¬mysqlʹÓÃgbk±àÂ룬VS2005ĬÈϹ¤³Ì¶¼ÊÇunicodeµÄ È»ºó²éѯһ¸ö×ֶεÄËùÓÐÊý¾Ý ·¢ÏÖÈç¹ûµÚÒ»ÌõÊý¾ÝΪÖÐÎÄ£¬ÄÇôÕâÌõÊý¾Ý²»»á´æÔÚ²éѯ½á¹ûÖÐ ²¢ÇÒ£¬ºóÃæµÄËùÓеÄÖÐÎļǼµÄ²éѯ½á¹ûÖУ¬Ã¿¸öÖÐÎÄ×Ö·ûÖ»ÓÐÒ»¸ö×Ö½Ú£¬¶øgbkÊÇ2¸ö×Ö½Ú´æ´¢Ò»¸öÖÐÎÄ×Ö·û ͬÑùµÄÊý¾Ý£¬ÔÚVC6.0ÖеIJéѯ½á¹û¾ÍÊÇ2¸ö×Ö½Ú ºÃ·Ñ½â£¡ ÒÔ½â¾ö£¬µ÷ÓÃÒ»ÏÂmysql_set_character_setÈ«¸ã¶¨ ¸Ð¾õʹÓÃvisual studio²éѯµÄ½á¹û»á°´ÕÕ×Öĸ×Ô¶¯ÅÅÐò ÖÐÎÄÊý¾Ý×Ô¶¯ÅÅÔÚÓ¢ÎÄÊý¾ÝºóÃæ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0)) { AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......
±í CREATE TABLE `ch1` ( `id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `no` int(10) unsigned DEFAULT NULL, `dtime` datetime DEFAULT NULL, PRIMARY KEY (`id ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ ¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ ÓóÌÐòÔ ......
¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬ Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ a ......