ÈçºÎ×ömysql µÄÎ÷ÎÄÄ£ºýËÑË÷£¿
ÍøÕ¾Òª·Òë³ÉÎ÷°ÎÑÀÎĵġ£µ«ÊÇËÑË÷¾ÓÈ»ÎÞЧÁË¡£
SQL ÊÇ×î¼òµ¥µÄ like '%key%'
ÏÖÏóÊÇ£¬Èç¹ûÕâ¸ökey Ö»º¬ÓÐÓ¢ÎĵÄ26¸ö×Öĸ£¬ÄÇô¾ÍÄÜËÑË÷³öÀ´£¬µ«ÊÇÈç¹ûº¬ÓзÇ26¸ö×ÖĸµÄÀýÈ磨organización£© Õâ¸öµ¥´Ê£¬¾ÍËÑË÷²»³öÀ´£¬ÔÚphpmyadminÀïÒ²ËÑË÷²»³öÀ´£¬
ÈçºÎ¸ãÄØ£¿
Ö´ÐÐÓï¾ä֮ǰÄãµÃÏÈ֪ͨmysql,phpÒµÎñ¶ËÏ£ÍûÓÃʲô±àÂëÓëmysql½»»¥, Ò²¾ÍÊÇ'organización'Õâ¸öÊý¾ÝÊÇʲô±àÂë
mysql_query("set names ....");
ÓÃÖ§³ÖÎ÷°ÎÑÀÎĵıàÂë¾Í¿ÉÒÔÁË¡£MYSQL PHP¶¼Òª
°Ñmysql×Ö·û¼¯¸Ä³ÉÎ÷°àÑÀÓïµÄ×Ö·û¼¯
×Ö·û¼¯µÄÎÊÌâ¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
×Ö·û¼¯¶¼ÓõÄUTF8 ¡£ ÓõÄFCK¸ø¿Í»§×öµÄºǫ́£¬ÊäÈëÊä³ö¶¼Õý³££¬¾ÍÊÇËÑË÷²»ÐС£¡£¡£
ÎÒÒ²Åö¹ý
ÎÒÒ²Åö¹ý
Â¥ÉÏÕâλÐǪ̈¡£¡£ÄúÓöµ½¹ý ¾Í˵˵զ½â¾öµÄÈö¡£¡£¡£¡£Õâ²»ÊǶºÎÒÂ𣿣¿
select * from a where binary col like '%a%'
ÕâÑùOK²»£¿
ÎÒÈÏΪSQL LIKEÒ»¶¨ÐеÄ,Ö»ÊÇÒªÐÞ¸ÄһЩÅäÖÃÎļþµÈ.ÄѵÀ˵Î÷°àÑÀ¾ÍûÓгÌÐòÔ±ÁË,¾ÍûÓÐÍøÒ³¼ìË÷ÁËÂð?
»¹Ò»¸öͨÓýâ¾ö·½·¨¾ÍÊÇÈ¡ÏûLIKE,»»ÓÃËÑË÷ÒýÇæ,ÍÆ¼öSPHINX,¿ÉÒÔ¿¼ÂÇÒ»ÏÂ,ÎÞÂÛÊǼìË÷ËÙ¶È»¹ÊÇÐÔÄܶ¼Ìá¸ßÒ»¸öµµ´Î!
»Ø9Â¥ Õâ¸ö·¨×ÓÓùýÁË¡£¡£¡£»¹ÊDz»ÐС£¡£»¹ÓÐɶ˼·Âð£¿
ÎÒÔÙ¶¥Ò»Ï¡£¡£¡£¡£
Êý¾Ý¿â×Ö·û¼¯ÉèÖÃΪutf8µÄ£¬È»ºóPHPÀ´²éѯµÄʱºòÉèÖÃÎ÷°àÑÀµÄ×Ö·û¼¯°¡£¬ÏÈ¿´ÏÂÊý¾Ý¿âÖ§³Ö²»¡£
ÊÔһϡ£
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
ÎÒ¿ª·¢ASP.netʱ
²åÈëÍâÎÄÂÒÂë
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......