Java开发网 - oracle9i 乱码问题,817显示正常

Java开发网

您没有登录

» Java开发网 » Database/JDBC/SQL/JDO/Hibernate

打印话题 寄给朋友 订阅主题

作者

oracle9i 乱码问题,817显示正常

yl9448

发贴: 3
积分: 0

于 2008-06-11 10:02

ORACLE: ORACLE9.2.0.7
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: WE8ISO8859P1

JAVA代码如下:
<%@ page import="java.sql.,java.text.,java.util.*" errorPage="" %>
<%@ page language="java" contentType="text/html;charset=UTF-8"%>
<%
String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin Angry

localhost:1521:oracle";
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
Class.forName(sDBDriver);
try {
conn = DriverManager.getConnection(sConnStr, "user", "password");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from table1");
while (rs.next()) {
out.println(":" + "
");
}
conn.close();
}

catch (Exception e){
String err= e.getMessage();
String des = new String(err.getBytes("GBK"),"ISO8859-1");

out.println (e.getMessage () + "\n");
out.println("" +des + "");
out.println("
");
out.println("" +err + "");

}
%>

注:1. table1不存在,主要想输出oracle 错误提示
2. oracle 817 显示正常

想输出oracle 错误提示,但
des输出一直是乱码,高人指点一下

作者	Re:oracle9i 乱码问题,817显示正常 [Re:yl9448]
yl9448 发贴: 3 积分: 0	于 2008-06-11 10:23 没人遇到这个问题吗?

作者	Re:oracle9i 乱码问题,817显示正常 [Re:yl9448]
JiafanZhou 版主发贴: 736 积分: 61	于 2008-06-13 15:57 I would guess String des = new String(err.getBytes("GBK"),"ISO8859-1"); uses the wrong charset. Try to use the charset utf-8 instead. Thanks, Jiafan When I was a kid I used to pray every night for a new bike. Then I realized that The Lord doesn't work that way, so I stole one and asked him to forgive me.

已读帖子

新的帖子

被删除的帖子