Thread: JDBC Encoding Issue (...again...)

JDBC Encoding Issue (...again...)

From
Ron St-Pierre
Date:
I am having the same problem that others have had - some characters in
the database are not being displayed properly because my database coding
is set to SQL_ASCII and not to UNICODE. I am using postgres 7.3.4 and
the jdbc driver from pg73jdbc.jar. I've seen from the thread ->Re:
[HACKERS] Charset encoding and accents<- in the archives at
http://archives.postgresql.org/pgsql-jdbc/2001-09/msg00005.php that I am
not allowed to change the encoding when creating my Connection object.

I was wondering if there is a *temporary* workaround that I can use to
either a) change the encoding when creating the connection, or b)
prevent anyone from entering non-SQL_ASCII characters into the database.
One of our clients has 8 databases which are using the SQL_ASCII
encoding and I can't just take them down and fix them. When 7.4 stable
is out we will probably upgrade the database and change the encoding at
the same time, but in the meantime we have a problem.

Any ideas?

Thanks
Ron