ºìÁªLinuxÃÅ»§
Linux°ïÖú

Ïòmysql²åÈëÊý¾ÝÂÒÂë½â¾ö·½°¸

·¢²¼Ê±¼ä:2008-06-04 00:03:28À´Ô´:ºìÁª×÷Õß:Ioonvme
ÏÖÏó:ÓÃJDBC½«ÖÐÎÄ×ֶβåÈëMySQLÊý¾Ý¿âÖУ¬È»ºó´ò¿ª±í·¢ÏÖ£¬ÄÇЩ×ֶζ¼ÊÇ"??",»òÕßÊÇÂÒÂë.

Ô­Òò:

1.´´½¨Êý¾Ý¿âʱûÓÐÖ¸¶¨Ä¬ÈϵıàÂ뷽ʽ£¬µ¼ÖÂÊý¾Ý¿âʹÓÃÁËMySqlµÄĬÈÏ×Ö·û¼¯latin1¡£

2.Client¶Ë×Ö·û¼¯Îªlatin1.

3.½øÐÐjdbcÁ´½ÓʱʹÓÃÁ˲»Æ¥ÅäµÄ×Ö·û¼¯¡£

½â¾ö°ì·¨£º
1.´´½¨Êý¾Ý¿âʱ½«Êý¾Ý¿âµÄȱʡ×Ö·û¼¯Ö¸¶¨Îªutf8¡£sqlÓï¾äû²éµ½...

2.ÐÞ¸ÄClientĬÈÏ×Ö·û¼¯Îªutft¡£windowsÏÂÔÚmysql°²×°Ä¿Â¼ÏÂÕÒµ½my.ini,½«ÀïÃæµÄdefault-character-set=latin1 ¸ÄΪdefault-character-set=UTF8£¬È»ºóÖØÆðmysql·þÎñ¼´¿É½«Êý¾Ý¿âĬÈÏ×Ö·û¼¯¸ÄΪutf8.´ËʱӦ¸ÃÔÚmysqlÃüÁîÐÐÓÃ\sÃüÁî¼ì²éһϿ´ÊÇ·ñ¸ÄºÃÁË¡£

3.ÐÞ¸ÄjdbcµÄÁ´½Ó£¬½«Ô­À´µÄ

jdbc:mysql://localhost:3306/YourDb
¸ÄΪ
jdbc:mysql://localhost:3306/YourDb?useUnicode=true&characterEncoding=UTF-8

×öÍêÒÔÉϹ¤×÷ºó£¬²åÈëµ½mysqlµÄÖÐÎÄÓ¦¸Ã²»»áÔÙÊÇÂÒÂëÁË.
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 0 ÌõÆÀÂÛ