hibernate ²åÈëoracleÊý¾Ý ÂÒÂë
ÎÒµÄoracleÊý¾Ý¿â×Ö·û¼¯ÊÇUS7ASCII£¬Ò³Ãæ×Ö·û¼¯ÊÇUTF-8£¬²åÈëÖÐÎÄÊý¾ÝºóÊÇÂÒÂ룬ÕâÖÖ×Ö·û¼¯²»Í³Ò»µÄÇé¿ö¸ÃÔõô°ì£¿Íû¸ßÊÖÖ¸½Ì¡£Êý¾Ý¿âµÄ×Ö·û¼¯ ÊDz»Äܸü¸ÄÁË¡£
ΪʲôÊý¾Ý¿â×Ö·û¼¯²»ÄܸÄÁË£¿
ÏÈÈ·¶¨ÄÇÀï³öÎÊÌâÁË£¬²»ÐоÍת»»±àÂë
1¡¢×Ô¼º×ªÂë
2¡¢¸ÃÊý¾Ý¿â×Ö·û¼¯
²éѯµÄʱºò£¬ÔÚÄãµÄ³ÌÐòÖжÔÈ¡³öÀ´µÄÊý¾Ý½øÐÐתÂë
String t = new String(rs.getString(1),"GBK");
Èç¹ûÄãµÄÊý¾Ý¿â±àÂëÊÇGBK»òÕßlatinÖ®ÀàµÄ£¬ÐèҪתÂë±ÈÈçÊý¾Ý¿âÀï´æ·ÅµÄÊÇGBK£¬ÐèÒª2²½×ª»», str=new String(rs.getBytes(1),"GBK"); ÔÙstr=new String(str.getBytes("UTF-8"),"GBK")£¬²Å¿ÉÒÔÕýÈ·ÏÔʾÖÐÎÄ¡£
show sql¿´ÏÂhibernate²å½øÈ¥µÄÊDz»ÊÇÂÒÂë~~~Ó¦¸Ã²»»áÊÇhibernate½øÊý¾Ý¿â²úÉúµÄÂÒÂ룬ÊdzÌÐòµÄÎÊÌâ
Ϊʲô²»°ÑÊý¾Ý¿âµÄ±àÂ뷽ʽ¸ÃÁËÄØ£¿
ÄǾͲ»ÓÃÀ´»Ø×ªÁ˰¡
²»»áÊDZàÂ뷽ʽ²»Ò»ÑùµÄ½á¹û£¬
ÊÇÄãµÄ³ÌÐòÎÊÌâ
Äã´Óǰ̨µ½ºǫ́£¬Ò»Ö±¸ú×Ùµ÷ÊÔ
´ó²¿·ÖÊÇÄãǰ̨ºÍºǫ́µÄ±àÂë²»Ò»Ñù
Õâ¸öºÍÊý¾Ý¿âû¶à´ó¹ØÏµ
дһ¸ö¼Ì³ÐActionServlet,ÖØÐ´ proess,ÉèÖÃrequest.setCharacterEncoding("utf-8");
¾Ñé·á¸»£¬ÃæÃæ¾ãµ½
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......