JDBC 連接informix 中文字符集轉換失敗
0
JDBC 連接informix ，informix 數據庫字符集設置為big5. 客戶端語言環境為UTF-8,數據庫字段存在“墻”，“銹”字符時，
獲取數據失敗
url詳細：
url=jdbc:informix-sqli://192.168.0.1:8015/dsx:INFORMIXSERVER=on_tcp8;NEWLOACLE=en_us,zh_cn,zh_tw;
NEWCODESET=utf8,big5,57352;DB_LOCALE=zh_TW.57352;CLIENT_LOCALE=zh_TW.57352
錯誤信息：
獲取數據失敗
url詳細：
url=jdbc:informix-sqli://192.168.0.1:8015/dsx:INFORMIXSERVER=on_tcp8;NEWLOACLE=en_us,zh_cn,zh_tw;
NEWCODESET=utf8,big5,57352;DB_LOCALE=zh_TW.57352;CLIENT_LOCALE=zh_TW.57352
錯誤信息：
Caused by: java.sql.SQLException: 不支援編碼或內碼集.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413)
at com.informix.jdbc.IfxChar.fromIfx(IfxChar.java:235)
at com.informix.jdbc.IfxRowColumn.a(IfxRowColumn.java:380)
at com.informix.jdbc.IfxRowColumn.a(IfxRowColumn.java:282)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:4775)
at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:669)
at com.informix.jdbc.IfxResultSet.b(IfxResultSet.java:641)
at com.informix.jdbc.IfxResultSet.getObject(IfxResultSet.java:1511)
at com.informix.jdbc.IfxResultSet.getObject(IfxResultSet.java:809)
hxf330
10年前提問