Postgres Pro
Downloads
Home   >   mailing lists

Migrate postgres databases from SQL_ASCII to UNICODE encoding - Mailing list pgsql-jdbc

From Dario V. Fassi
Subject Migrate postgres databases from SQL_ASCII to UNICODE encoding
Date
Msg-id 40F98613.1060405@sistemat.com.ar
Whole thread Raw
Responses Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE encoding
List pgsql-jdbc
Tree view

A simple question, we need to migrate many (>20) postgres databases from SQL_ASCII encoding to UNICODE encoding, over a 7.3.6 server.

With  Dump/Restore , we get an error (Invalid Unicode) in any field that has a 8 bits character coming from the SQL_ASCII , even setting the client_encoding to WIN, ISO-8859-1,  and others encodings.

I'm really worried about this problem since , we have many DBs to migrate and even with a ODBC program we can't port tables from Postgresql/SQL_ASCII to Postgresql/UNICODE.

Any suggestion will be *very* appreciated.

Regards,
Dario.


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: patch: fix hopelessly broken decodeUTF8() method
Next
From: Tom Lane
Date:
Subject: Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE encoding