Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚMySQLתÂëÎÊÌâ

and ezuser.login = post.author 
ÉÏÊösqlÌõ¼þ µÄloginÊÇutf-8±àÂ룬authorÊÇlatin±àÂë

Èç¹ûÁ½±ß¶¼ÊÇÓ¢ÎĵÄûʲôÎÊÌ⣬Èç¹ûÊÇÖÐÎÄ ÔòÊý¾Ý¶ªÊ§£¬
ѰÇó½â¾ö°ì·¨£¬µÈ´ýÖС£¡£¡£¡£
ÄãÒâ˼ÊÇ˵£¬ Äܲ»ÄÜÓÃÖÐÎÄ×÷Ϊ±íµÄ×Ö¶ÎÃû£¿

ллÏÈ£»
²»ÊÇÄǸöÒâ˼
post.authorÊÇÊý¾Ýlatin ±àÂë  ÎÒÒª°ÑÊý¾Ýת³Éutf8±àÂë

ÓÃphp iconv ½øÐÐתÂë

Â¥ÉϵĶԲ»Æð£¬ ÎÒ˵µÄ²»ÊǺÜÇå³þ£¬
ÎÒ˵µÄÖ»ÄÜÓÃphpmyadnmin À´²Ù×÷ £¬
¾ÍÊÇֻдsqlÓï¾äÀ´Íê³É¡£

post.authorÊÇÊý¾Ýlatin ±àÂë  ÎÒÒª°ÑÊý¾Ýת³Éutf8±àÂë
------------------------------------

»¹ÊDz»Ã÷°×£¬ ÄãµÄ"and ezuser.login = post.author " ²»ÊÇsqlÓï¾äÂ𣿠post²»ÊDZíÂð? authorÊDz»ÊÇ×Ö¶ÎÃû?

postÊÇ±í£¬authorÊÇ×Ö¶ÎÃû ÎÊÌâÊÇÕâ¸ö×Ö¶ÎÊÇlatin±àÂ룬ÎÒÏÖÔÚÒª°ÑÊý¾Ý±ä³Éutf8 ±àÂë
²»È» ÖÐÎÄÊý¾Ý»á¶ªÊ§£¬£¬ÒòÎªÇ°ÃæµÄ login ×Ö¶ÎÊÇ utf8 ±àÂë ¡£

and ezuser.login=CONVERT(post.author USING utf8)

Â¥É쵀 ÕâÖÖ·½·¨ÎÒÓùýÁË£¬Ã»Ó᣻¹ÊÇлл
µÈ´ýÖС£¡£¡£¡£

and CONVERT(ezuser.login USING utf8)=CONVERT(post.author USING utf8)

µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html

ÒýÓÃ
Â¥É쵀 ÕâÖÖ·½·¨ÎÒÓùýÁË£¬Ã»Ó᣻¹ÊÇлл
µÈ´ýÖС£¡£¡£¡£


àÅ,¶ÔÁË,ÄãÊÇ´Ólatin1ת,¿Ï¶¨Ã»ÓÃ,ÒòΪLatin1ÀïûÖÐÎÄ,ÖÐÎͼµ±³É2¸öÅ·ÖÞ×Ö·ûתÁË.....

ÄãÕâ¸öҪôµ¼³öµ¼ÈëÒ»ÏÂ,ת³ÉgbkÔÙÓÃ....µ±È»Èç¹û¿ÉÒÔÖ±½Ó×


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

netbeans Á¬mysql - Web ¿ª·¢ / HTML(CSS)

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......

mysqlÖÐÎÄÂÒÂë - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ