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´æ´¢ÎÄ×Ö£¬ÕâÑù¾ÍÎÞËùνʲô±àÂ룬ËäÈ»ÓеãÂé·³£¬²»¹ýȷʵÓÐЧ¡£
¶àл¸
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÔÚvbÕâ±à³ÌÀïËÆºõÓкܶàµÄ¶«Î÷ÊÇÏàÁªÏµµÄ£¬ÎªÊ²Ã´ÓÐЩÈ˶ÔvbµÄ±à³ÌÃþ²»µ½Í·ÄÔ°¡£¡²¢ÇÒÓÐЩʺÜÈÝÒ׵쬵«ÊÇÈ´°ÑËüÃǵĴúÂë±ä³É¸´ÔÓ£¬Ò²È¥ÏëһЩ²»ÄÜʵÏֵĶ«Î÷°¡£¡
û·ÖÁË£¬Â¥Ö÷¶àÀ´µã·Ö£¡
À´½Óµã·Ö
......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÔÚÏÂÊÇvbµÄÐÂÊÖ£¬Ïëд¶Î³ÌÐò£¬ÔÚvbÖУ¬Ê¹ÓÃwscriptµ÷ÓÃһЩÍⲿµÄÃüÁµ«ÊdzÌÐòÖ´ÐÐÒ»Ö±ÓдíÎó£¬Çë¸÷λ¸ßÊÖ°ïæ½â´ðÏ£¬Ð»Ð»¡£
´úÂëÈçÏ£º
VB code:
Private Function getFile_CMD(filename, filepath) As Bo ......
ÎÒдÁËÒ»¸öÈí¼þ£¬ÒªÓõ½ACCESSÊý¾Ý¿â£¬ÎÒÔÙ·ÃÎÊACCESSµÄʱºò£¬ÎÒÐèÒª´Ó±íÀï¶Á³öÒ»ÐÐÊý¾Ý£¬ÎҵijÌÐòÊÇÕâÑùдµÄ£¬SQLSTRING="SELECT * from '" &ME.TEXTBOX1.TEXT &"' WHERE ID = '"& ......