Re: SQL_ASCII charset conversion

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  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.