Re: SQL_ASCII charset conversion - Mailing list pgsql-jdbc

From Radosław Smogura
Subject Re: SQL_ASCII charset conversion
Date
Msg-id 201108251903.54049.mail@smogura.eu
Whole thread Raw
In response to SQL_ASCII charset conversion  (Dieter <dieter.salathe@syslink.ch>)
List pgsql-jdbc
Hi,

I bearly looked at driver code, and I see setting charSet is possible only if
databse is 7.3 or earlier.

I think better solution will bo for you to dump databse to sql, and eventually
fix encoding with iconv. You may try to set system encoding /in Your session/
to ASCII or better to ISO-8859-1 and take dump, then create database with
proper encoding (or change database creation to reflex desired encodind in
dumped file). If you will restore database from such file, and such session
everything should work. I hope.

Regards,


Dieter <dieter.salathe@syslink.ch> Thursday 25 of August 2011 12:41:44
> 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-tp473
> 3958p4733958.html Sent from the PostgreSQL - jdbc mailing list archive at
> Nabble.com.

pgsql-jdbc by date:

Previous
From: Maciek Sakrejda
Date:
Subject: Re: jdbc and LibreOffice on Ubuntu: slow performance
Next
From: Radosław Smogura
Date:
Subject: Re: SQL_ASCII charset conversion