mysqlµÄ¹ÜÀí¹¤¾ßnavicat 8.0±íÖÐÊý¾ÝÎÞ·¨´æ´¢ÖÐÎÄÎÊÌâ
ʹÓõÄÊÇnavicat 8.0°æ±¾£¬´´½¨Ò»¸ö±í£¬µ«ÊDZíµÄÊôÐÔ²»¹ÜÊÇchar»¹ÊÇvarchar£¬ËäÈ»ÊäÈëºó¿ÉÒÔÏÔʾ³öÀ´£¬µ«ÊÇÎÞ·¨±£´æ£¬Ò»µã»÷±ðµÄµØ·½¾ÍÓдíÎóÌáʾ¡°1366-Incorrect string value:xe7\x8e\x8b for column 'ÐÕÃû'at row 1¡±,²¢ÇÒÒѾÄܹ»±£Ö¤Á¬½ÓÊôÐÔÖС°¸ß¼¶¡±ÖеıàÂëΪ¡°65001(UTF-8)¡±,ÇëÎÊÓ¦¸ÃÔõÑù´æ´¢ ºº×Ö£¿£¿
лл~{{
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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.
¿ÉÊÇÎÒÕÒ ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ
Ö§³Ö£¬¼ì² ......