mysql5µÄ×Ö·û¼¯ºÍsql modeÎÊÌâ
http://hi.baidu.com/gushu/blog/item/3e821c174eabec064a90a7d4.html
mysql5Ìí¼ÓÁËһЩÐµĹ¦ÄܵĹæÔò£¬ÆäÖжԿªÔ´³ÌÐòÓ°Ïì±È½Ï´óµÄÓÐÁ½¸ö£¬Ò»¸öÊÇ4.0.12+¿ªÊ¼µÄ4²ã´Î×Ö·û¼¯£¬Ò»¸öÊÇ5.0.18¿ªÊ¼µÄĬÈÏstrict mode¡£
¶ÔÓÚÕâÁ½¸öÎÊÌ⣬ЧÂÊ×îºÃµÄ½â¾ö·½°¸£¬¾ÍÊÇÖ±½ÓÐÞ¸Ämy.ini
# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=utf8
#ÕâÀï¸Ä³Éutf-8
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES£¬ NO_AUTO_CREATE_USER£¬ NO_ENGINE_SUBSTITUTION"
#ÕâÀï¸Ä³É=""
µ±ÄãûÓÐȨÏÞ½øÐÐÐÞ¸Äʱ£¬¾ÍÖ»ºÃÔÚ³ÌÐòÖÐÅжÏÁËmysql5 й¦ÄÜ£¬±ØÐëÔÚÿ´ÎÁ¬½ÓÉÏÊý¾Ý¿âʱ½øÐÐÉ趨¡£ÔÚʹÓÃÁËÊý¾Ý¿â³éÏó²ãµÄ³ÌÐòÖÐÐÞ¸ÄÆðÀ´Ò²ºÜ¼òµ¥£º
if(mysql_get_server_info( $connect ) > '4.0.1')
{
mysql_query( "set names 'utf8'" £¬ $connect );
}
if(mysql_get_server_info( $connect ) > '5.0.1')
{
mysql_query("SET sql_mode=''" £¬ $connect );
}
Ïà¹ØÎĵµ£º
Õû¸öSQLºÍAsp.net(vb.net)Ò»Æð´ò°üµÄÈ«¹ý³ÌдһÏ¡£
Ò».×¼±¸±ØÒªµÄÎļþ
1. SQL½Å±¾Îļþ£¬Éú³ÉÒÔºó°²×°¹ý³ÌÖÐÐèÒªµÄ±íºÍ´æ´¢¹ý³ÌµÈµÈ£»
Éú³ÉÖ®ºó£¬¾ÍÔÝʱ°ÑËüÃüÃûΪdb.sql(×¢Òâ´óСд)
2.LisenceFile.rtfµÄ°²×°Îļþ£¬ÒòΪÎÒµÄϵͳÊǸöÈ˵쬶øÇÒfreeµÄ£¬ËùÒÔ¾ÍûÓÐ×ö¡£Õâ¸öÒÔºóÒ²ÊÇÒªÓõ½µÄ¡£
¶þ.ÔÚ×Ô¼ºÏÖÓеÄÏîÄ¿Àïà ......
*
* ¹¦ÄÜ˵Ã÷:±¸·ÝºÍ»Ö¸´SQL ServerÊý¾Ý¿â
* ×÷Õß: Áõ¹¦Ñ«;
* °æ±¾:V0.1(C#2.0);ʱ¼ä:2007-1-1
* µ±Ê¹ÓÃSQL Serverʱ,ÇëÒýÓà COM×é¼þÖеÄ,SQLDMO.dll×é¼þ
* µ±Ê¹ÓÃAccessÖÐ,Çëä¯ÀÀÌí¼ÓÒýÓÃÒÔÏÂÁ½¸ödll
* ÒýÓÃC:/Progra ......
1¡¢¿ªÊ¼->³ÌÐò-->Microsoft SQL Server 2005>ÅäÖù¤¾ß->SQL Server Configuration Manager->SQL Server 2005 ÍøÂçÅäÖà ->“xxx£¨ÄúµÄÊý¾Ý¿â£©”µÄÐÒ飬ÈçÏÂͼ
½«“Named Pipes”ºÍ“TCP/IP”µÄ״̬µ÷³É“ÆôÓÔ£¬·½·¨ÊÇÔÚ“Named Pipes”ºÍ“T ......
½â¾ö°ì·¨£ºÔÚÁ¬½Ó×Ö·û´®ÖÐ˵Ã÷Á¬½Ó×Ö·ûµÄÊôÐÔ£¬È磺
<add name="server_mysql" connectionString="server=127.0.0.1;user id=root; password=123; database=baiduemail; pooling=false;charset=gbk"/>
»òÕßÊÇ;charset=gb2312
ÁíÍâ×¢Ò⣺ÔÚ´´½¨mysqlÊý¾Ý¿âµÄ±íµÄʱºòÑ¡Ôñ±àÂ뼯gbk ......