This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reading NVarChar2 from Oracle 10g database

Chris Mack
Posts: 13
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

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:
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic