Question

jsp向oracle插入 中文 数据出错ORA-01460: unimplemented or unreasonable conversion requested 求大神！

在jsp中向oracle插入英文没问题，直接用PL/SQL向oracle插入中文和英文也没问题。跪求高手解释！

Answer 1

可能是字符集不一致 插入时转下码

追问

怎么转码？求赐教

追答

插入一条记录:
Connection conn=null;
PreparedStatement pstmt = null;
try {
String strSql="insert into tabA(A,B) values('1111','王超')";
conn=ds.getConnection();
strSql = new String(strSql.getBytes("GBK"), "ISO-8859-1");
pstmt = conn.prepareStatement(strSql);
pstmt.executeUpdate();
}catch (Exception e) {
//logger.error(e, e);
}finally {
disconn(conn, pstmt);
}
查询一条记录:
Connection conn=null;
PreparedStatement pstmt = null;
ResultSet rs=null;
try {
String strSql="select B from tabA where A='1111'";
conn=ds.getConnection();
strSql = new String(strSql.getBytes("GBK"), "ISO-8859-1");
pstmt = conn.prepareStatement(strSql);
rs=pstmt.executeQuery();
String strB;
if (rs.next()){
strB=new String(rs.getString(1) .getBytes("ISO-8859-1"), "GBK");
} catch (Exception e) {
//logger.error(e, e);
}finally {
disconn(conn, pstmt, rs);
}

http://blog.163.com/khq_hit/blog/static/889680201111425421409/ 我也是在这里找的

Answer 2

jdbc驱动的问题吧，你试试换个新的驱动包或者装个高版本的jdk。