Winform+MySQL×öÏîÄ¿
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔCS¶þÑÔ£¬Èç¹ûÄãÒªÌá¸ßÐÔÄÜ£¬¾¡Á¿¼õÉÙDBÉϵĸ´ÔÓ²Ù×÷£¬°Ñ¼ÆËãѹÁ¦´«¸øCS³ÌÐò¡£ºÜ¶àÈ˶¼Ï°¹ß°ÑһЩ¸´ÔӵļÆËãͳ¼Æ¶¼×öÔÚDBÉÏ£¬Õâ¶ÔCS¶þÑÔÊǸö×îʧ°ÜµÄÉè¼Æ¡£
2.CSÉϵÄÐÔÄÜÌáÉý¹Ø¼üÔÚÓÚ2¸ö£¬1¸öÊÇËã·¨£¬Áí1¸ö¾ÍÊÇÌåÑéЧ¹û¡£Ëã·¨¹ýÓÚ¸´ÔӵĿÉÒÔ²ð·Ö¶àÏ̴߳¦Àí£¬¶ÔÓÚËã·¨¹ý¶àºÄʱµÄ£¬ÊµÔÚûÓÐÓÅ»¯µÄ¿ÉÄÜÁË£¬¶à¼ÓUIÌåÑéЧ¹û£¬±ÈÈç½ø¶ÈÌõµÈ´ý£¬ÌáÐÑ£¬ÕâЩ²Ù×÷¶¼ÓÐÀûÓÚÔö¼ÓÈËÃǶÔÄãµÄ³ÌÐòµÄºÃ¸Ð¶È
Êý¾Ý¿âÓÅ»¯, »º´æ, ¶àÏß³Ì ... ...
·¹ý
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
Java code:
Ä£ºý²éѯÊé°´ÕÕÊéÃû-------------------
java.sql.SQLException: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
at com.mys ......
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
¸ßÊÖ£¬ÏÖÔÚÓöµ½Ò»¸ömysql±¸·ÝµÄÎÊÌâ¡£
ÎÒµÄÊý¾Ý¿âÀïÓÐһЩÓÃcreate function½¨Á¢µÄ×Ô¶¨Ò庯Êý¡£µ±ÎÒÓÃmysqldump±¸·Ý¸ÃÊý¾Ý¿âÈ»ºóµ¼Èëµ½ÁíÍâÒ»¸ö·þÎñÆ÷BÉÏ£¬·¢ÏÖ·þÎñÆ÷BÉÏÖ»ÓÐÊý¾Ý£¬¶øÃ»ÓÐÄÇЩ×Ô¶¨ÒåµÄº¯Êý¡£Î ......