Á½Ì¨Mysql·þÎñÆ÷£¬Êý¾Ýͬ²½
ÏÖÔÚÓÐÒ»¸öÍøÕ¾£¬ÏëÔÚÁíÍâһ̨·þÎñÆ÷ÉÏ×öÒ»¸öÕâ¸öÍøÕ¾µÄ¾µÏñ¡£
ÔÚÖ÷ÍøÕ¾ÉϵÄÊý¾Ý¸üÐÂҪͬ²½µ½¾µÏñ·þÎñÆ÷ÉÏ
ͬʱÓû§·ÃÎʾµÏñ·þÎñÆ÷ʱµÄÊý¾Ý¸üÐÂҲҪͬ²½µ½Ö÷ÍøÕ¾ÉÏ
ÆäÖÐÊý¾Ý¸üРÖ÷Òª°üÀ¨ MysqlÊý¾Ý¿âµÄ¸üРºÍ Óû§ÉÏ´«µÄÎļþ¸üÐÂ
ÎÒÏÖÔÚÔÚ¿´mysqlÊý¾Ý¿âµÄͬ²½¡£ ÔÚÁ½Ì¨·þÎñÆ÷ÉϵÄmysqlÊý¾Ý¿âÖ®¼äµÄͬ²½
ÍøÉϲéÁËÏÂmysqlÈȱ¸·Ý£¬´ó¶à½²µÄÊÇÊý¾Ý´Ó Ö÷·þÎñÆ÷ µ½ ´Ó·þÎñÆ÷ÉÏ¡£½²Ë«ÏòÈȱ¸µÄ±È½ÏÉÙ¡£ÓÉÓÚmysqlÈȱ¸·ÝÊÇÒì²½´¦ÀíµÄ£¬¶ÔÓÚauto_increment×ֶεÄÖµ£¬Ë«ÏòÈȱ¸µÄʱºò²»ÖªµÀ»á²»»á³öÎÊÌ⣿
»¹ÓÐMysql´Ø£¬ÎÒ»¹Ã»ÓÐ×Ðϸ¿´¡£
Ï£Íû´ó¼Ò¿ÉÒÔ¸øСµÜÌṩһЩ½¨ÒéºÍ·½°¸£¬Ð»Ð»¡£
û×ö¹ý£¬°ï¶¥¡£
°ï¶¥°É
û×ö¹ý µÈ´ý´óÅ£ÃÇÀ´¸øÄã½â´ð
ÎÒ¿´ÁËÏÂMysql´Ø£¬×÷ΪӲ¼þµÄ¼¸Ì¨·þÎñÆ÷Ö®¼ä´ø¿íÒª´ïµ½100Mbps£¬Ö»ÄÜÊÇÒ»¸ö¾ÖÓòÍøÖ®ÄÚ²ÅÐУ¬ÔÚ¹ãÓòÍøºÜÄÑʵÏֳɹ¦£¬Ò²²»ÍƼöÔÚ¹ãÓòÍø¼ÜÉè¡£
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......
ÎÒʹÓÃC#Á¬½ÓmysqlÊý¾Ý¿â¶ÁÈ¡ÆäÖеÄÊý¾Ý£¬
¶ÁÈ¡Êý¾Ý±íÖеÄVarcharÀàÐ͵ÄÊý¾Ý£¬Èç¹ûÊÇÓ¢ÎÄÄܹ»Õý³£¶ÁÈ¡³öÀ´£¬
¶øÈç¹ûÊÇÖÐÎÄ£¬¾Í»áÏÔʾΪ¡°£¿£¿¡±£¬
Èç¹û°ÑvarcharÀàÐÍ»»³ÉbinaryÀàÐÍ£¬Asp.net³ÌÐòÄܹ»Õý ......
MySQLÃüÁîÊäÈë´íÎóºó,Ö´ÐдíÎóÃüÁî·¢³ö¿ÉŵĽÐÉù
ÔõôÑù½â¾ö???
ÄǽÐÉùÒô¸úÖ¸Õë¶ÁÊý¾Ý¶Á´íÁË,·¢³öÒ»Ñù¿ÉÒÔŵĽÐÉù
¸ãµÄÎÒ²»¸ÒÓÃÃüÁîÐÐ
ºÇºÇ£¡lzÕæ¿É°®£¡
·½·¨Ò»£¬°ÑÄãµÄPCÉϵÄÀ®°È²ð³ý
·½ ......
Java code:
Ä£ºý²éѯÊé°´ÕÕÊéÃû-------------------
java.sql.SQLException: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
at com.mys ......