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

C#¶ÁÈ¡mysqlÊý¾Ý¿âÎÊÌâ

ÎÒʹÓÃC#Á¬½ÓmysqlÊý¾Ý¿â¶ÁÈ¡ÆäÖеÄÊý¾Ý£¬
¶ÁÈ¡Êý¾Ý±íÖеÄVarcharÀàÐ͵ÄÊý¾Ý£¬Èç¹ûÊÇÓ¢ÎÄÄܹ»Õý³£¶ÁÈ¡³öÀ´£¬
¶øÈç¹ûÊÇÖÐÎÄ£¬¾Í»áÏÔʾΪ¡°£¿£¿¡±£¬

Èç¹û°ÑvarcharÀàÐÍ»»³ÉbinaryÀàÐÍ£¬Asp.net³ÌÐòÄܹ»Õý³£ÏÔʾÊý¾Ý¿âÖеÄÖÐÎÄ×Ö·û£¬
¶øwinform³ÌÐò°ó¶¨Êý¾Ýʱ£¬ÏÔʾ²ÎÊýÒì³££¬ÎÒ»³ÒÉÊÇmysqlÊý¾Ý¿âµÄ×Ö·û±àÂëÎÊÌ⣬ÎÒµÄmysqlÊý¾Ý¿âĬÈÏ×Ö·û¼¯ÉèÖõÄÊÇgbk.

Çë½Ì¸÷λCSDNµÄÅóÓÑ£¬ÓÐʲô½â¾ö°ì·¨Âð?


http://blog.csdn.net/fengying0529/archive/2009/08/12/4436998.aspx
Õâ¸öÓ¦¸Ã¿ÉÒÔ½â¾öÄãµÄÎÊÌâ

¶þÂ¥Õý½â...

¶¥¶þÂ¥

ÊÔÊÔÔÚÁ¬½Ó×Ö·û´®ÀïÃæÌí¼ÓÒ»¸öcharset="gb2312"

ÒýÓÃ
½«MySQLµÄ±àÂëÉèÖÃΪutf8¾ÍûÓÐÎÊÌâÁË£¬ÒòΪASP.NETµÄĬÈϱàÂëÒ²ÊÇutf8¡£
Òª²»¾ÍÔÚweb.configÖн«ASP.NETµÄ±àÂëÉèÖÃΪgbk£¬MySQLµÄ±àÂë±£³Ögbk²»±ä¡£
ÉÏÃæµÄ×ö·¨Êǽâ¾öÂÒÂëµÄ¼òµ¥·½·¨¡£
ͬÑùÒ²¿ÉÒÔÊý¾Ý¿âÈÔÈ»²ÉÓÃgbk±àÂ룬ASP.NETÒ²²ÉÓÃutf8±àÂ룬²»¹ýÔÚ±àÂë´¦Àíʱ»á¸´ÔÓһЩ¡£

Èç¹û°ÑmysqlµÄ±àÂëÉèÖÃΪutf8ÔÚÏò±íÖвåÈëÖÐÎÄÊý¾Ýʱ£¬¾Í»áÖ±½Ó±¨´í£¬
Èç¹ûÉèÖÃAsp.netµÄ±àÂëΪgbk£¬¶ÁÈ¡ÖÐÎÄÊý¾Ýʱ£¬»¹ÊÇÏÔʾ²»ÕýÈ·µÄ¡£

ÒýÓÃ
http://blog.csdn.net/fengying0529/archive/2009/08/12/4436998.aspx
Õâ¸öÓ¦¸Ã¿ÉÒÔ½â¾öÄãµÄÎÊÌâ


Õâ¸ö·½·¨ÎÒÒ²ÊÔ¹ýÁË£¬ºÃÏñ»¹ÊDz»ÐÐѽ£¡

ÒýÓÃ
ÊÔÊÔÔÚÁ¬½Ó×Ö·û´®ÀïÃæÌí¼ÓÒ»¸öcharset="gb2312"

color=#3366FF]ÄܾßÌåÒ»µãÂð£¿[[/col


Ïà¹ØÎÊ´ð£º

C# Á¬½ÓSQLÊý¾Ý¿â³£ÓõÄÁ¬½Ó×Ö·û´®¸ÃÈçºÎд£¿

£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";   
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......

javaÁ¬½Ómysql±»¾Ü¾ø

ÎÒÔÚ³ÌÐòÀïÃæÐ´ÁËÒ»¸ö¼àÌýÆ÷£¬TomcatÆô¶¯µÄʱºò¾Í»áÈ¥¼ì²âÊý¾Ý¿âÊÇ·ñÁ¬½ÓÉÏÁË£¬µ«ÊDZ¨ÁË´í
Access denied for user 'root'@'localhost' (using password: YES)
·ÃÎʱ»¾Ü¾ø£¬ÔõÑùÐ޸ķÃÎÊÓû§µ ......

ÕÒmysql·þÎñͻȻµ±µôÔ­Òò

linuxÉϵÄmysql·þÎñÔÚ½Ú¼ÙÈÕͻȻµ±µô
ÏÖÔÚÕÒÔ­Òò£¬»³ÒÉÊÇ´ÅÅ̿ռ䲻¹»£¬ÏÖÔÚÐèÒªÕÒµ½È·ÔäµÄÖ¤¾Ý¡£
£±¡¡¾ßÌåÔÚÄĸöÎļþÏ¿ÉÒÔÕÒµ½£¬Ëûµ±µôµÄ¾ßÌåʱ¼äºÍÔ­Òò£¿
£²¡¡windowsÏÂcÅÌ¿ÉÒÔ±¨´ÅÅ̿ռ䲻¹»µÄÔ­Òò£¬²» ......

mysqlÁ¬½ÓÎÊÌâ

Á¬½ÓÊý¾Ý¿âʱÔõô³öÏÖÕâÑùµÄ´íÎó£º[localhost] ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)
ÔΣ¬Óï¾äÌùÀ´¿´¿´
ÄãÃÜÂëÄØ

ÃÜÂë´íÁ˰ɡ£

¸Õѧmysql,ÕÕ×ÅÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ