KOI8-R Problems!

From: Meder Bakirov <bakirov(at)transfer(dot)kg>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: KOI8-R Problems!
Date: 2002-10-18 05:49:14
Message-ID: 200210181149.14555.bakirov@transfer.kg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello list!

I have searched the net, but didn't find a solution, so finally I'm writing
here - to the list!

I have encountered a problem with a KOI8-R encoding in Postgresql! The problem
is that, I cannot store Russian characters in database from JSP or servlets,
they are stored as ????? (i.e. substitutes each russian char to ?).

JSP and servlets work fine with KOI8-R, I can enter and display back russian
chars in KOI8-R from JSP and servlets. I use
request.setCharacterEncoding(response.getCharacterEncoding) in my servlets,
and contentType="text/html"; charset=KOI8-R in my JSP files, both of them
work fine with each other - russian chars are displayed normally.

Now, JDBC part!

When connecting to database, I set Connection properties of charSet=KOI8-R.
That is, props.setProperty("charSet","KOI8-R");

I use SQL_ASCII as a default encoding, but it is not a problem, I can store
russian chars from psql. I tried creating database with encoding 'KOI8-R',
but it did not solve a problem. Also, I tried setting properties of
encoding=KOI8-R, but it also did not make any changes!

The interesting part is that, when I insert russian chars from psql, they are
normally displayed on my JSP page. And it makes me think, that a problem is
in Java+Postgresql chain somewhere.

But, anyway, I didn't give up with this issue and I hope I will solve this
problem in short time. But now, I need your help and hints to make a move
forward! :)

I can't finish my project, because of this issue :) Actually, I have - it
works, but with English chars only!

Anyway, thank you very much and sorry for a time, taken!

--
Rgrds, .coder!

Browse pgsql-jdbc by date

  From Date Subject
Next Message G.Nagarajan 2002-10-18 13:35:40 Re: Performance problem iterating a resultset
Previous Message lalit 2002-10-18 01:49:40 Re: Support for javax.sql.DataSource ..