大家好，sybase中txt类型乱码的问题！谢谢

loveshi

免费乐捐，感谢支持

大家好，我有个问题要请教，我用createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);然后读取数据集的时候sybase中的txt值是乱码，string值没问题，如果直接createStatement();则都无问题，现在我要取得记录数要用rs.last();，而rs.last(); 就要用第一种！怎么解决这个乱码的问题啊，谢谢了！

loveshi

[em01][em02][em03][em04][em05][em06][em08][em09][em10][em11][em12][em13][em14]

flybean

奇怪。能不能提供代码片段，以及数据库字符集设置？

loveshi

数据库字符集是cp936

ResultSet rsPNode = sybconnId.Query(sql);

System.out.println(rsPNode.getString("p_txt"));

public ResultSet Query(String sql) {
ResultSet rs = null;
try {
conn = getConnection();
if (conn == null)
return null;
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);///就是这一行的变动
rs = stmt.executeQuery(sql);
System.out.println("........... Resulset get success");
}
catch (SQLException e) {
System.err.println("dbBean:executeQuery():" + e.getMessage());
}
return rs;
}

而且无论用哪种方式都不成|

System.out.println(rsPNode.getString("p_txt"));
System.out.println(rsPNode.getString("p_txt").getBytes());//
System.out.println(rsPNode.getString("p_txt").getBytes("GB2312"));//3
System.out.println(rsPNode.getString("p_txt").getBytes("ISO8859_1"));//4
System.out.println(new String(rsPNode.getString("p_txt").getBytes()));//5
System.out.println(new String(rsPNode.getString("p_txt").getBytes(),"GB2312"));//6
System.out.println(new String(rsPNode.getString("p_txt").getBytes(),"ISO8859_1"));//7
System.out.println(new String(rsPNode.getString("p_txt").getBytes("GB2312")));//8
System.out.println(new String(rsPNode.getString("p_txt").getBytes("GB2312"),"GB2312"));//9
System.out.println(new String(rsPNode.getString("p_txt").getBytes("GB2312"),"ISO8859_1"));//10
System.out.println(new String(rsPNode.getString("p_txt").getBytes("ISO8859_1")));//11
System.out.println(new String(rsPNode.getString("p_txt").getBytes("ISO8859_1"),"GB2312"));//12
System.out.println(new String(rsPNode.getString("p_txt").getBytes("ISO8859_1"),"ISO8859_1"));//13

将编码改成cp936也还是不行

System.out.println(rsPNode.getString("p_txt").getBytes("cp936"));

…………