ÎÊÒ»¸ö×Ö·û¼¯µÄÎÊÌ⣬´Ó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ÁË¡£
Ä㻹ÐèҪʲô?
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......