ÎÊÒ»¸ö×Ö·û¼¯µÄÎÊÌ⣬´Ó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"); Õý½â mysql_query("set names gb2323"); ÔÚÁ¬½ÓÒ³ÃæÖоͰÑËûÉèºÃ Èç¹ûÊÇ×Ô¼ºµÄ»úÆ÷£¬¿ÉÐÞ¸Ä my.ini Îļþ лл¥Éϼ¸Î»µÄÈÈÐÄ£¬¿ÉÊÇ»¹ÊÇûÓнâ´ðÎÒµÄÎÊÌâ¡£ ûÓÐÈËÄܹ»»Ø´ðô¡£¡£¡££¿ ÎÒÏë¸úÄã˵£¬²»ÒªÔÚ·þÎñÆ÷ÉÏÉèÖÃĬÈϵÄ×Ö·û¼¯£¬ÓÃʲô×Ö·û¼¯ÄÇÊǿͻ§¶ËµÄÊ¡£ Ïȼì²éËùÓеijÌÐòÎļþÊÇʲô±àÂ룬ÊÇ·ñͳһ¡£ Ö»ÒªÊÇͳһµÄ±àÂë¾Í²»»á³öÏÖÂÒÂëµÄÎÊÌâ¡£Èç¹ûÒÔǰÊý¾Ý¾ÍÒѾ²»¶ÔÁË£¬ÄÇÖ»ÓÐÔÚ³ÌÐòÀï¼ÓÉÏsetÁË¡£ÒýÓà лл¥Éϼ¸Î»µÄÈÈÐÄ£¬¿ÉÊÇ»¹ÊÇûÓнâ´ðÎÒµÄÎÊÌâ¡£ ûÓÐÈËÄܹ»»Ø´ðô¡£¡£¡££¿ Ä㻹ÐèҪʲô?
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......
ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏ ֱ½ÓÓÃMYSQLDUMP±¸·Ý OR ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£ http://dev.mysql.com/doc/re ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
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 ......