¹ØÓÚ²åÈëMySqlÊý¾ÝÖÐÎÄÂÒÂëÎÊÌâ
ΪɶÎÒ²åÈëµÄÖÐÎͼÊÇ?? NETÁ¬½ÓMySqlÊý¾Ý¿â,
ÄÄΪ¸ßÈ˸ø¸öºÜºÃµÄ½â¾ö·½·¨.°¡
Êý¾Ý¿âµÄÊôÐÔÉèÖÃΪGB2132ÊÔ¿´¿´
×Ö·û¼¯µÄÎÊÌ⣿
¾ßÌåЩ,¶¼²»ÖªµÀÔõô»ØÊÂ
ÎÒÕÒµ½½â¾öµÄ°ì·¨ÁË
ÔÚÒ»¸öÑ¡Ôñ×Ö·û¼¯£¨ÓÐÈý¸ö×Ö·û¼¯Ñ¡ÏµÄ°²×°½çÃæÉÏÑ¡Ôñgkb¡£
Éè³ÉGBK..Èç¹ûÓпÉÊÓ»·¾³¿ÉÖ±½ÓÔÚÊý¾Ý¿âÉÏÉèÖÃ×Ö·û¼¯
ÓÃVS¿ª·¢ASP.NETĬÈϱàÂëÊÇutf-8±àÂ룬°²×°MySQLʱѡÔñutf-8±àÂ룬´ÓÀ´Ã»ÓгöÏÖÄã˵µÄÎÊÌâ¡£
ÔÚдÈëÊý¾Ý¿âµÄ³ÌÐòÖнøÐбàÂëת»»¡£
°ÑUTF-8±àÂëת±äΪGB2312±àÂ룬ÔÙдÈëÊý¾Ý¿â¡£
´ÓÊý¾Ý¿â¶ÁÈ¡ÊÇÔÙ´ÓGB2312ת»¯ÎªUTF-8.
ÓÖ¼ûÖܹ«£¬¾´Àñ~~~
°Ñ Êý¾Ý×ֶεıàÂë¸Ä³É utf-8
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º
Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£
Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
select * from table where '123456789' like '%'+×ֶαí+'%'
Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......