ÎÊÒ»¸ö×Ö·û¼¯µÄÎÊÌ⣬´Ómysql°æÀ´
ÔÌûÇë¿´
http://topic.csdn.net/u/20100115/09/98c6ac75-d6fe-4b6c-90dc-336a738a0c0f.html?14601
×ܽáϾÍÊÇ
apache php mysql ÎÒÈ«²¿¶¼ÓõÄÊÇgb2312£¬ÓÐʲô°ì·¨¿ÉÒÔ²»ÓÃÿ´Îmysql_query('SET character_set_results=gb2312')£¬¶ø±£Ö¤ÖÐÎÄÏÔʾÕý³£
Çë¸ßÊÖÖ¸µã
ʲô½Ðÿ´Î? Äãconnectºóдһ¾ä set character_set_results,( set names ) ¾ÍÐÐÁË.
ÁíÄãÔÌûÖÐ
ÔÚmy.cnf ÀïµÄ[client]дӦ¸ÃÊǹÜÓõÄ,ÉèÖõÄÊÇdefaultµÄÖµ
mysql_query("set names gb2323");
Õý½â
mysql_query("set names gb2323");
ÔÚÁ¬½ÓÒ³ÃæÖоͰÑËûÉèºÃ
Èç¹ûÊÇ×Ô¼ºµÄ»úÆ÷£¬¿ÉÐÞ¸Ä my.ini Îļþ
лл¥Éϼ¸Î»µÄÈÈÐÄ£¬¿ÉÊÇ»¹ÊÇûÓнâ´ðÎÒµÄÎÊÌâ¡£
ûÓÐÈËÄܹ»»Ø´ðô¡£¡£¡££¿
ÎÒÏë¸úÄã˵£¬²»ÒªÔÚ·þÎñÆ÷ÉÏÉèÖÃĬÈϵÄ×Ö·û¼¯£¬ÓÃʲô×Ö·û¼¯ÄÇÊÇ¿Í»§¶ËµÄÊ¡£
Ïȼì²éËùÓеijÌÐòÎļþÊÇʲô±àÂ룬ÊÇ·ñͳһ¡£
Ö»ÒªÊÇͳһµÄ±àÂë¾Í²»»á³öÏÖÂÒÂëµÄÎÊÌâ¡£Èç¹ûÒÔÇ°Êý¾Ý¾ÍÒѾ²»¶ÔÁË£¬ÄÇÖ»ÓÐÔÚ³ÌÐòÀï¼ÓÉÏsetÁË¡£
Ä㻹ÐèҪʲô?
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽ ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
PHPCMSÆóÒµ»ÆÒ³2008·ÖÒ³ÎÊÌâ
ÎÒÓÃÒÔÏ·½Ê½Çóƽ¾ùÊý
{get sql="SELECT DISTINCT c.*,
(select round(avg(sort1)) from `phpcms_yp_dp` where userid=c.userid) avgsort1,
(select round(avg(avgp ......