¹ØÓÚMySQLתÂëÎÊÌâ
and ezuser.login = post.author ÉÏÊösqlÌõ¼þ µÄloginÊÇutf-8±àÂ룬authorÊÇlatin±àÂë Èç¹ûÁ½±ß¶¼ÊÇÓ¢ÎĵÄûʲôÎÊÌ⣬Èç¹ûÊÇÖÐÎÄ ÔòÊý¾Ý¶ªÊ§£¬ ѰÇó½â¾ö°ì·¨£¬µÈ´ýÖС£¡£¡£¡£
ÄãÒâ˼ÊÇ˵£¬ Äܲ»ÄÜÓÃÖÐÎÄ×÷Ϊ±íµÄ×Ö¶ÎÃû£¿ ллÏÈ£» ²»ÊÇÄǸöÒâ˼ post.authorÊÇÊý¾Ýlatin ±àÂë ÎÒÒª°ÑÊý¾Ýת³Éutf8±àÂë ÓÃphp iconv ½øÐÐתÂë Â¥ÉϵĶԲ»Æð£¬ ÎÒ˵µÄ²»ÊǺÜÇå³þ£¬ ÎÒ˵µÄÖ»ÄÜÓÃphpmyadnmin À´²Ù×÷ £¬ ¾ÍÊÇֻдsqlÓï¾äÀ´Íê³É¡£ post.authorÊÇÊý¾Ýlatin ±àÂë ÎÒÒª°ÑÊý¾Ýת³Éutf8±àÂë ------------------------------------ »¹ÊDz»Ã÷°×£¬ ÄãµÄ"and ezuser.login = post.author " ²»ÊÇsqlÓï¾äÂ𣿠post²»ÊDZíÂð? authorÊDz»ÊÇ×Ö¶ÎÃû? postÊÇ±í£¬authorÊÇ×Ö¶ÎÃû ÎÊÌâÊÇÕâ¸ö×Ö¶ÎÊÇlatin±àÂ룬ÎÒÏÖÔÚÒª°ÑÊý¾Ý±ä³Éutf8 ±àÂë ²»È» ÖÐÎÄÊý¾Ý»á¶ªÊ§£¬£¬ÒòÎªÇ°ÃæµÄ login ×Ö¶ÎÊÇ utf8 ±àÂë ¡£ and ezuser.login=CONVERT(post.author USING utf8) Â¥É쵀 ÕâÖÖ·½·¨ÎÒÓùýÁË£¬Ã»Ó᣻¹ÊÇлл µÈ´ýÖС£¡£¡£¡£ and CONVERT(ezuser.login USING utf8)=CONVERT(post.author USING utf8) µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù. http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.htmlÒýÓà ¥É쵀 ÕâÖÖ·½·¨ÎÒÓùýÁË£¬Ã»Ó᣻¹ÊÇлл µÈ´ýÖС£¡£¡£¡£ àÅ,¶ÔÁË,ÄãÊÇ´Ólatin1ת,¿Ï¶¨Ã»ÓÃ,ÒòΪLatin1ÀïûÖÐÎÄ,ÖÐÎͼµ±³É2¸öÅ·ÖÞ×Ö·ûתÁË..... ÄãÕâ¸öҪôµ¼³öµ¼ÈëÒ»ÏÂ,ת³ÉgbkÔÙÓÃ....µ±È»Èç¹û¿ÉÒÔÖ±½Ó×
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0)) { AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8 ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿ MySQL 5.1²Î¿¼ÊÖ²á ÒýÓà ÐÖµÜÄã»á½áÌùÂ𣿠mysql ²Î¿¼ÊÖ²á baidu MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
try { sql::Driver *driver; sql::Connection *con; //´´½¨Á¬½Ó driver = get_driver_instance(); con = driver->connect("tcp://192.168.18.52:3306", "root", "1234 ......