有关DB2开发过程码值转换的问题
如下异常信息:
Message:unsupported encoding Cp1386 for result set column
SQLState:22021
SQL error code:-99999
主要代码为:
public String bytesToString (byte[] bytes){
String value = "";
try {
//value = new String(bytes,"Cp1252"); //iso8859-1
//value = new String(bytes,"utf-8"); //utf-8
//value = new String(bytes,"gbk"); //???
value = new String(bytes,"Cp1386"); //??
}catch(UnsupportedEncodingException ioe){
System.out.println(ioe.getMessage());
}
return value;
}
try{
//执行检索,获得结果集
ResultSet rs = st.executeQuery(sql);
while(rs.next()){
for (int i=1; i < 4; i++)
result += " [" + bytesToString(rs.getBytes(i)) + "] ";
result += "\n";
}
//显示结果
textDisplay.setText(result);
rs.close();
}catch(SQLException sqlE){
//System.out.println(sqlE.getSQLState());
System.out.println("Message:"+sqlE.getMessage());
System.out.println("SQLState:"+sqlE.getSQLState());
System.out.println("SQL error code:"+sqlE.getErrorCode());
}