• Post Reply Bookmark Topic Watch Topic
  • New Topic

Reading NVarChar2 from Oracle 10g database  RSS feed

Chris Mack
Posts: 13
  • 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 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!



  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!