mysqlÖÐÎÄÂÒÂë - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽÊÇutf8
ÇëÎÊÕâÁ½¸öÎÊÌâÔõô½â¾ö£¿
°ï¶¥MYSQL
.
MYSQL?°ï¶¥.
·¢´íµØ·½ÁË£¬ÕâÀïÊÇMS-SQL Server
ENCODING.DEFAULTÄØ
Èø´ïÄ·
×Ö·û¼¯Éè³É¡¡utf8¡¡ÊÔÊÔ
1¡¢ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â,ÖÐÎIJåÈëmysqlµÄʱºò£¬set names 'gbk';
2¡¢Ê¹ÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ룺set names 'gbk';
utf8±àÂë:set names 'gbk';
Õâ¸ö¾«±Ù¡£¡£¡£
²Î¿¼Ò»ÏÂÕâ¸öÌù×ÓÖеļì²é·½·¨¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
¿ÉÒԲο¼ÎÒ²©¿ÍÖеķ½·¨½â¾öÏ£¬ËäÈ»ÊÇjavaÖУ¬µ«ÎÒÏëÓ¦¸ÃÊÇÏàͨµÄ¡£
http://blog.csdn.net/cxh8318/archive/2009/05/08/4161858.aspx
¿ÉÒԲο¼ÎÒ²©¿ÍÖеķ½·¨½â¾öÏ£¬ËäÈ»ÊÇjavaÖУ¬µ«ÎÒÏëÓ¦¸ÃÊÇÏàͨµÄ¡£
http://blog.csdn.net/cxh8318/archive/2009/05/08/4161858.aspx
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒ¿ª·¢ASP.netʱ
²åÈëÍâÎÄÂÒÂë
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......
ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£
ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......