SQL_ASCII charset conversion

From: Dieter <dieter(dot)salathe(at)syslink(dot)ch>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: SQL_ASCII charset conversion
Date: 2011-08-25 10:41:44
Message-ID: 1314268904633-4733958.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi

we have a Postgres 8.4 database with SQL_ASCII encoding.

Unfortunately, there are non ascii characters stored in this database. The
encoding used to store the non-ascii characters was ISO-8859-1 (LATIN1). I
know thats not the way to go, but thats the situation.

With the old Postgres JDBC Driver (older than 7.2), the charSet Property
could be as follows:
charSet=ISO-8859-1
With this setting, the characers in the database are correctly interpreted.

Now, with the new 8.4 postgres JDBC driver, this charSet setting is not
supported anymore.
How can I set the character encoding to ISO-8859-1 in the 8.4 Postgres
Driver?

Thank you very much.

Regards
Dieter

--
View this message in context: http://postgresql.1045698.n5.nabble.com/SQL-ASCII-charset-conversion-tp4733958p4733958.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Ulf Mehlig 2011-08-25 14:33:51 jdbc and LibreOffice on Ubuntu: slow performance
Previous Message Jonas Sundman 2011-08-25 05:57:23 Re: getTablePrivileges empty if table owned by group role