ÏÖÏó:ÓÃ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µÄÖÐÎÄÓ¦¸Ã²»»áÔÙÊÇÂÒÂëÁË.