¹ØÓÚMySQLµÄ±àÂëÎÊÌâ
ÔÚmyeclipseÖÐʵÏÖÓëmysqlµÄÁ¬½Ó£¬µ«³öÏÖÁËÂÒÂëÏÖÏó£¬
mysqlÖеÄmy.iniÎļþÖÐĬÈϵͼÊÇlatin-1.ÎÊÔõôÑù²ÅÄÜÉèÖóÉutf-8»òÕßGBK¡£»¹ÓеľÍÊÇutf-8¡¢GBKºÍLatin-1ÈýÕßµÄÇø±ð
¸Ð¼¤²»¾¡
Â¥Ö÷×îºÃ»¹Êǽ«MysqlµÄ±àÂëÉèÖÃΪgb2312£¬ÖØ×°Ò»´ÎMysql£¬ÔÚÖØÐ½¨¸öÊý¾Ý¿â£¬
Latin-1²»Õ¦Ö§³ÖÖÐÎÄ£¬UTF-8Ö§³ÖÖÐÎÄ£¬GBKÖ§³ÖÖÐÎÄ£¬ÊÇ·±ÌåµÄ±àÂë
ÕâÖÖÎÊÌ⻹µÃ¿¿×Ô¼º Google.com.hk.............
latin-1 ¾ÍÊÇ ISO 8859-1 Ã÷°×ÁËô£¿
֨װ mysql ÅäÖÃÓïÑÔ»·¾³ÎªGBK
ʵÏÖmysqlÁ¬½Ó ÔÚÁ¬½Ó´Ê¼ÓÉÏ
?useEncoding=true&characterEncoding=UTF-8
¸ü¸ÄMySQLÊý¾Ý¿â±àÂ룺
ÔËÐÐMySQL Server Instance Confituration Wizard³ÌÐò£¬¸ù¾ÝÏòµ¼Ò»Ö±µã»÷¡°next¡±£¬µ±µ½ÅäÖÃÊý¾Ý¿â±àÂëÕâÒ»²½Ê±£¬×¢Ò⣬ѡÔñ×îºóÒ»¸öµ¥Ñ¡°´Å¥£¨Manual Selected Default Character Set/Collation£©£¬ÔÚÏÂÀ¿òÖÐÑ¡Ôñutf-8£¨Ä¬ÈϱàÂëΪlatin1£©£¬È»ºó°´Ïòµ¼Íê³ÉÅäÖü´¿É¡£
ÄãµÄJSPÎļþµÄÍ·ÎļþûÓÐÉèÖóÉutf-8°É£¿
Èç¹ûûÓеϰ¾Í²»Ö§³ÖÖÐÎÄ£¬¿Ï¶¨»áÂÒÂ룡
LZµÄÎÊÌâÎÒÓö¼û¹ý£¬ÄãÔÚ°²×°MYSQLµÄʱºò£¬ÓÐÒ»²½ÊÇ Please select the default set.Äã°ÑCharacter Set:Ñ¡ÔñΪGB2312¾ÍÐÐÁË
ÔÚ°²×°Ê±Óиö×Ö·ûÑ¡ÔñµÄÎÊÌâ £¬Ö»ÒªÑ¡ÎªGB2312¼´¿É
ÔËÐÐMySQL Server Instance Confituration WizardÀ´ÉèÖóÉutf-8£¬Êý¾Ý¿â¡¢±í¶¼ÒªÉèÖóÉutf-8¡£
°ÑÍøÒ³ÖеIJÎÊýת³Éutf-8¸ñʽ£¬´æÈëÊý¾Ý¿â¡£
Ö±½Ó²éѯ³öµÄÊý¾ÝÓ¦¸ÃÊÇutf-8µÄ¸ñʽ£¬²»ÓÃת»»¡£
ÒªÊÇÓô¿javaµÄ´úÂë´æÈëÊý¾ÝµÄ»°£¬Ò²ÓгöÏÖÂÒÂëµÄÇé¿ö¡£
ÍøÒ³ÖнÓÊܵÄÊý¾Ýת³Égb2312Ò²¿ÉÒÔ´æÈëÊý¾Ý¿âµÄ¡£
ÖØÐÂÅäÖÃmysql
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
try
{
sql::Driver *driver;
sql::Connection *con;
//´´½¨Á¬½Ó
driver = get_driver_instance();
con = driver->connect("tcp://192.168.18.52:3306", "root", "1234 ......
ÈçÌâ¡£Äܲ»Äܸø¸öÀý×Ó£¬·Ç³£¸Ðл
°²×°mysqlʱ¼ÇµÃ×° Àà¿â£¬ÀïÃæÓÐ mysqlÌṩµÄº¯Êý½è¿Ú£¬ÓÃËüÀ´Á¬mysqlºÜ·½±ã
ºÃ¶«Î÷£¬¹²Í¬Ñ§Ï°
mysql++ À࣬ºÜ·½±ãºÜºÃÓã¡
ÌùÓÊÏ䣬·¢Äã
1.mysql api
2.myodbc
......