²åÈëmysqlÊý¾Ý¿âÂÒÂëÎÊÌâ
Ã÷Ã÷´ÓÍøÒ³½ÓÊյIJÎÊý¶¼ÊÇÖÐÎÄ£¬²¢ÇÒÓÃout.print()´òÓ¡³öÀ´Ò²ÊÇÖÐÎÄ,µ«ÎªÊ²Ã´ÏòmysqlÊý¾Ý¿â²åÈëʱ±ä³ÉÁË£¿£¿£¿£¿ºÅ~~
mysqlÊÇɶ±àÂ뷽ʽ
show variables like '%char%' ¸÷ÖÖÅäÖúóÔËÐиÃÃüÁîÏÔʾÈçÏ£º
____________________________________
character_set_client | gb2312
|
character_set_connection | gb2312
|
character_set_database | gb2312
|
character_set_filesystem | binary
|
character_set_results | gb2312
|
character_set_server | gb2312
|
character_set_system | utf8
_________________________________________
ÅäÖãº
ÔÚ°²×°¹ý³Ì »òÕß°²×°¹ýºóÑ¡Ôñ MySQL Server Instance Configuration Wizard ½øÐÐÅäÖÃʱ£¬ÅäÖõ½ÈçͼËùÊ¾Ò³Ãæ£¬°´Í¼ÖÐËùʾÅäÖ㺣¨×¢ÒâºìÉ«ÇøÓò£©
˳±ã˵һ¾ä£¬Ò³ÃæµÄ±àÂë×îºÃͳһ
mysqlÓà µÄ ÊÇgbk ÍøÒ³ÓõÄÒ²¶¼Êǹó±ö¿¨
˵Ã÷Äã´Óǰ̨°ÑÊý¾Ý²åÈëÊý¾Ý¿âÕâ¸ö¹ý³ÌÖÐÓÐÎÊÌ⣬Ӧ¸ÃÊÇ×Ö·û±àÂëÎÊÌ⣬
Äã°ÑÊý¾Ý¿â±àÂë¸Ä³ÉÉÏÃæËµµÄ£¬¿´Ðв»ÐУ¬
Ò²¾ÍÊÇ˵Äã²åÈëµ½Êý¾Ý¿âµÄÊÇÂÒÂëÁË£¿
Ð޸ĸöÅäÖÃÎļþ¡£¡£D:\mysql5.0
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......