Reg loading Unicode data from DB

[Sathya Sekar]

Hello friends,

I have a basic doubt wrt to ensuring internationalization support in Java applications. In my Java code, I try to "enforce" UTF8 encoding by doing:

PreparedStatement pst = connection.prepareStatement("SELECT...");
ResultSet rst = pst.executeQuery();
...
String myInternationaltring = rst.getString("UniString");
String utf8String = new String(myInternationaltring .getBytes("UTF8"));

However, when the data value in the database is

Localiza��o Amostra

, the resultant

utf8String

string is mangled up :

BR|Localiza����o Amostra

However if I remove the encoding and just retain the String in the above code:

PreparedStatement pst = connection.prepareStatement("SELECT...");
ResultSet rst = pst.executeQuery();
...
String myInternationaltring = rst.getString("UniString");
String utf8String = new String(myInternationaltring);

the output is fine:[CODE]Localiza��o Amostra[/CPDE]

I am collecting information on the database but it might be UTF-16 as well. I am unclear on what I am doing wrong and what I should be doing to ensure internalionalization completely.

Could any kind soul pl help?

Thanks.

[Paul Clapham]

Do this:

String myInternationaltring = rst.getString("UniString");

and nothing else. The database driver and the database between them should take care of any encoding issues. And from what you say in your second example, that is already working. I don't understand why you think you have to do anything else.