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

¹ØÓÚ²åÈëMySqlÊý¾ÝÖÐÎÄÂÒÂëÎÊÌâ

ΪɶÎÒ²åÈëµÄÖÐÎͼÊÇ??  NETÁ¬½ÓMySqlÊý¾Ý¿â,
ÄÄΪ¸ßÈ˸ø¸öºÜºÃµÄ½â¾ö·½·¨.°¡
Êý¾Ý¿âµÄÊôÐÔÉèÖÃΪGB2132ÊÔ¿´¿´

×Ö·û¼¯µÄÎÊÌ⣿

¾ßÌåЩ,¶¼²»ÖªµÀÔõô»ØÊÂ


ÎÒÕÒµ½½â¾öµÄ°ì·¨ÁË

ÔÚÒ»¸öÑ¡Ôñ×Ö·û¼¯£¨ÓÐÈý¸ö×Ö·û¼¯Ñ¡ÏµÄ°²×°½çÃæÉÏÑ¡Ôñgkb¡£

Éè³ÉGBK..Èç¹ûÓпÉÊÓ»·¾³¿ÉÖ±½ÓÔÚÊý¾Ý¿âÉÏÉèÖÃ×Ö·û¼¯


ÓÃVS¿ª·¢ASP.NETĬÈϱàÂëÊÇutf-8±àÂ룬°²×°MySQLʱѡÔñutf-8±àÂ룬´ÓÀ´Ã»ÓгöÏÖÄã˵µÄÎÊÌâ¡£

ÔÚдÈëÊý¾Ý¿âµÄ³ÌÐòÖнøÐбàÂëת»»¡£
°ÑUTF-8±àÂëת±äΪGB2312±àÂ룬ÔÙдÈëÊý¾Ý¿â¡£
´ÓÊý¾Ý¿â¶ÁÈ¡ÊÇÔÙ´ÓGB2312ת»¯ÎªUTF-8.


ÒýÓÃ
ÓÃVS¿ª·¢ASP.NETĬÈϱàÂëÊÇutf-8±àÂ룬°²×°MySQLʱѡÔñutf-8±àÂ룬´ÓÀ´Ã»ÓгöÏÖÄã˵µÄÎÊÌâ¡£



ÓÖ¼ûÖܹ«£¬¾´Àñ~~~

°Ñ Êý¾Ý×ֶεıàÂë¸Ä³É utf-8


Ïà¹ØÎÊ´ð£º

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

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

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

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

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

MYSQL Êý¾Ý½ØÈ¡

MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï.
ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî
SQL code:
update ±í set introtxt=left(`fulltext`,300);

¶¥£¬Ñ§Ï°

SQL code: ......

mysql like ÎÊÌâ

select * from table where '123456789' like '%'+×ֶαí+'%'


Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ