vb+mysql utf8ÂÒÂëÎÊÌâ
¸÷λ¸÷룬Çë½ÌÒ»¸öÂÒÂëÎÊÌâ
ÎÒµÄvb6.0+mysql Á¬½Ó×Ö·û´®ÊÇ£º
Public Function ChinaTW() As String 'Á¬½ÓÊý¾Ý¿âº¯Êý
ChinaTW = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=localhost;" _
& "Port=3306;" _
& "DATABASE=chinashopping_tw;" _
& "UID=chinatw;PWD=123456; OPTION=3;stmt=SET NAMES utf8"
End Function
ÎÒÔÀ´ÊÇ gb2312,¸ù¾ÝÒªÇó£¬ÒªÖ§³Ö·±ÌåÖÐÎÄ£¬Òò´Ë£¬³öÏÖÁËÂÒÂë
Çë°ï棬лл£¡£¡
¸öÈ˶¥£¬Help me
Thanks!!
»áµÄÅóÓÑ£¬°ïÏÂæ£¬Â·¹ýµÄÅóÓÑ£¬¸ø¶¥ÏÂ
Thanks!
¸Õ¸ÕÊÔÁËÏ£¬gbkÃ²ËÆÃ»ÓÐÎÊÌâ
dingyanwei
ÄãºÃ£¬ÓÃgbk ÔÚ¼òÌåϵͳÉÏÕý³££¬µ«ÔÚ·±ÌåϵͳÉÏÊÇÂÒÂ룬Çë¼ÌÐø¹Ø×¢£¬Ð»Ð»£¡£¡
aohan:
ÄãºÃ£¬²»ÖªµÀÂÒÂëÎÊÌâºÍnvarcharÓÐʲôֱ½Ó¹ØÏµ£¿
лл
»¹ÊÇÅÜÌâºÃÁË£¬¼ÌÐøÌÖÂÛÂÒÂëÎÊÌâ
·¹ýµÄÅóÓÑ£¬°ï¶¥
лл
¸Õ²Å·ÖÎöÁËÏÂÎҵijÌÐò£¬ÔÀ´ÎÒÓõÄÊÇole×ֶΣ¬½¨ÒélzʹÓÃole´æ´¢ÎÄ×Ö£¬ÕâÑù¾ÍÎÞËùνʲô±àÂ룬ËäÈ»ÓеãÂé·³£¬²»¹ýȷʵÓÐЧ¡£
¶àл¸
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÔÚvbÕâ±à³ÌÀïËÆºõÓкܶàµÄ¶«Î÷ÊÇÏàÁªÏµµÄ£¬ÎªÊ²Ã´ÓÐЩÈ˶ÔvbµÄ±à³ÌÃþ²»µ½Í·ÄÔ°¡£¡²¢ÇÒÓÐЩʺÜÈÝÒ׵쬵«ÊÇÈ´°ÑËüÃǵĴúÂë±ä³É¸´ÔÓ£¬Ò²È¥ÏëһЩ²»ÄÜʵÏֵĶ«Î÷°¡£¡
û·ÖÁË£¬Â¥Ö÷¶àÀ´µã·Ö£¡
À´½Óµã·Ö
......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒдÁËÒ»¸öÈí¼þ£¬ÒªÓõ½ACCESSÊý¾Ý¿â£¬ÎÒÔÙ·ÃÎÊACCESSµÄʱºò£¬ÎÒÐèÒª´Ó±íÀï¶Á³öÒ»ÐÐÊý¾Ý£¬ÎҵijÌÐòÊÇÕâÑùдµÄ£¬SQLSTRING="SELECT * from '" &ME.TEXTBOX1.TEXT &"' WHERE ID = '"& ......