Home » Developer & Programmer » JDeveloper, Java & XML » Encoding problems with locale and jdbc - ResultSet.getString()
Encoding problems with locale and jdbc - ResultSet.getString() [message #91173] Wed, 15 May 2002 08:04 Go to next message
lenon
Messages: 5
Registered: May 2002
Junior Member
I get correct(slovak) encoding from ResultSet.getString() from my thin jdbc java application connecting to oracle8i, when 'regional options' locale on my w2k is set to slovak; switching to english i get '?'-question marks instead of correct characters.

I tried to alter session and change NLS_LANGUAGE and
NLS_TERRITORY to slovak; as well to set environment variable NLS_LANG, along with
Locale.setDefault(new Locale("sk","SK"))

No success, it works only with windows SK locale on.

What can I do?
I wonder what jdbc or jvm itself is getting from system environment and how it interfere with encoding, whether data are screwed in db-java transfer or java-screen (out.print())?
Re: Encoding problems with locale and jdbc - ResultSet.getString() [message #91174 is a reply to message #91173] Thu, 16 May 2002 00:03 Go to previous messageGo to next message
Mohamed Itani
Messages: 2
Registered: March 2002
Junior Member
Hello,

This is a serious problem, I already faced it with hungarian characters??

Can anybody suggests a solution for that??
Is there any solution on earth but changing the driver??

I already tried the nls_charset12.zip library but in vain.

This is so serious and it could prevent people from using the oracle jdbc/thin driver when they love it.

Best Regards
Itani Mohamed
Solution [message #91175 is a reply to message #91173] Thu, 16 May 2002 07:29 Go to previous message
lenon
Messages: 5
Registered: May 2002
Junior Member
I found solution to my problem, it has nothing to do with jdbc.

It's about character<->bytes encoding, as I suspected,
print/write methods of java writers classes use
'platform's default encoding' which is set by regional
settings of os; i tried just to add this line to my program: System.setProperty("file.encoding","CP1250");
(i need windows 1250 code page); but it doesn't work properly for me.

The solution is to set proper encoding to output writer
class. If you write to file, you need something like this:

FileOutputStream outt = new FileOutputStream("output.txt");
PrintWriter out = new PrintWriter(new OutputStreamWriter(outt,"WINDOWS-1250")); //or "ISO-8859-2" etc
out.println(resultset.getString(1)); //should work now

if you write to screen, you'll need wrap System.out stream

PrintWriter sout =new PrintWriter(new OutputStreamWriter(System.out,"WINDOWS-1250"),true);
sout.println(rs.getString(1)); //should work now
Previous Topic: jdbc problem whit decimal separator
Next Topic: Re: Where can i get the Oracle thin driver
Goto Forum:
  


Current Time: Thu Aug 05 00:51:36 CDT 2021