jQuery in Action, 3rd edition
The moose likes Java in General and the fly likes Reading NVarChar2 from Oracle 10g database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "Reading NVarChar2 from Oracle 10g database" Watch "Reading NVarChar2 from Oracle 10g database" New topic

Reading NVarChar2 from Oracle 10g database

Chris Mack

Joined: Feb 24, 2009
Posts: 13
I have a table with a field that is an NVarChar2 data type in an Oracle 10g database.
I am using a Java ResultSet to get the value out:
ResultSet rs = preparedStatement.executeQuery();
String s = rs.getString("column_name");

I now want to convert the characters of the string to UTF-8.

I have tried the following:

String utf8 = new String(s.getBytes("UTF-8"));

String utf8 = new String(s.getBytes("UTF-8"),"UTF-8");

String unicode= new String(s.getBytes("UTF-16");
String utf8 = new String(unicode.getBytes("UTF-8"));

and other variations of.

I have also tried getting the value out of the result set as a byte array and tried the same type of conversions as above. I still do not get the correct characters.
I also tried some of the other character encodings supported by Oracle, but I get java.io.UnsupportedEncodingException.

Does anyone know how to read an NVarChar out of an Oracle 10g database and convert it to UTF-8?

Any help would be appreciated!



I agree. Here's the link: http://aspose.com/file-tools
subject: Reading NVarChar2 from Oracle 10g database
It's not a secret anymore!