Mysql ʹÓÃÎÊÌâ - Java / Web ¿ª·¢
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ:SHOW VARIABLES LIKE '%charac%' ¿´¿´ÄãµÄÊý¾Ý¿â±àÂë Òª¸Ä±äÆäÖÐÒ»¸ö, ¾ÍʹÓà set character_set_client = UTF8; ÆäÖÐ character_set_client | utf8 ¿Í»§¶Ë, Ò²¾ÍÄ㵱ǰÃüÁîÐÐϵıàÂë, Ò²¿ÉÒÔʹÓÃset names gbkÕâÑùÉèÖà character_set_connection | utf8 Á¬½Ó±àÂë character_set_database | utf8 Êý¾Ý¿â±àÂë character_set_filesystem | binary Êý¾Ý¿âµ×²ãÎļþϵͳ±àÂë character_set_results | utf8 character_set_server | utf8 character_set_system | utf8 È«²¿×ªÎªutf-8ÊÔÊÔ°É. ±àÂëÎÊÌ⣬ËùÓеĵط½ÒªÊ¹ÓÃÏàͬµÄ±àÂ룻CMDºÚ´°¿ÚÀïÊÇÓõÄGBK±àÂ룬Äã³ÌÐòÀïÆäËûµÄµØ·½ÄØ£¿ ×Ö·û¼¯µÄÎÊÌâ °²×°µÄʱºò£¬ÈÃÄãÑ¡±àÂëµÄ£¬¿ÉÄÜÄãûÓÐ×¢Ò⣡ ÎÒÓõıàÂëÊÇgb2313£¡£¡ È»ºóÔÚMysql µÄ¿ÉÊÓ½çÃæÖиü¸ÄÊý¾Ýʱ Ëü²»Èøü¸Ä 1406 - data too long for column £¡£¡ ÎÒÓõıàÂëÊÇgb2312£¡£¡ È»ºóÔÚMysql µÄ¿ÉÊÓ½çÃæÖиü¸ÄÊý¾Ýʱ Ëü²»Èøü¸Ä 1406 - data too long for column £¡£¡ Èç¹û¿ØÖÆÌ¨´òÓ¡µÄÊÇÖÐÎÄ£¬ÄÇôӦ¸Ã²»ÄÜ»³ÒÉmysqlµÄ±àÂë¡£ ½¨ÒéÔÚResultSetÈ¡Êý¾ÝʱÈÕÖ¾´òӡһϣ¬¿´ÊÇ·ñ´ÓÊý¾Ý¿â¸Õ¶Á³öʱ¾ÍÊÇÂÒÂë¡£ Èç¹ûÊÇ£¬ÄÇô¿ÉÒÔÐÞ¸ÄmysqlĿ¼ÖеÄmy.iniÎļþ£¬ÀïÃæÓÐÁ½¸ö½Úµã¿ÉÒÔ¸ü¸Ä±àÂ뷽ʽÒýÓà ÎÒÓõıàÂëÊÇgb2312£¡£¡ È»ºóÔÚMysql
Ïà¹ØÎÊ´ð£º
ÎҵĿª·¢µÄƽ̨ÊÇMyeclipes6.0 + tomcat5.x + mysql ÎÒËùÓеıàÂ뷽ʽ¶¼ÊÇÓõÄUTF-8 ÎÒÖ»ÓÃÁËStrtus¿ò¼Ü ÔÚÒ»¸öformÖÐÈçÏÂÓõÄÊÇpostµÄÌá½»·½Ê½£º <form class="form" action=&quo ......
import java.io.*; class FileTest { public static void main(String [] args) throws Exception { File fDir=new File(File.separator); String strFile="javaÔ´´úÂë²âÊÔ"+File.separato ......
ÎÊÌâÃèÊö£ºÐ´ÈÕÖ¾¹¦ÄÜ£¬Ð´ºÃµÄдÈÕÖ¾·þÎñ£¬ÆäËûÓû§Í¨¹ýhttpµ÷Ó÷þÎñ£¬´«Èë²ÎÊý£¬È»ºó¼Ç¼ÈÕÖ¾£¬ ÎҵķþÎñ¸ÃÔõôд£¬ ±ðÈËÔõôͨ¹ýhttpµ÷ÓÃÎҵķþÎñ£¬ÎÒÓÃwebserviceдºÃÁËÒ»¸ö£¬¿ÉÊDz¢·¢ÓÐÉÏÏߣ¬Ïë¸ÄÓ ......
ÔÚÈýÊ®½²Óöµ½ÕâÑùÒ»¸öÎÊÌâ¾ÍÊÇÔËÐдúÂëʱ³öÏÖ´íÎó Fatal error: Call to undefined method mysql::fetch_array() in D:\WWW\news\index.php on line 12 £¬ÎÒ°Ñmysql::fetch_array() ¸Ä³Émysql::fetch_row() ÓÖ³öÏÖF ......