| From: | "Dario V(dot) Fassi" <software(at)sistemat(dot)com(dot)ar> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Migrate postgres databases from SQL_ASCII to UNICODE encoding |
| Date: | 2004-07-17 20:03:31 |
| Message-ID: | 40F98613.1060405@sistemat.com.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-jdbc pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-07-17 20:15:21 | Re: [HACKERS] Point in Time Recovery |
| Previous Message | Tom Lane | 2004-07-17 19:18:26 | Re: [HACKERS] Point in Time Recovery |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-07-17 21:18:16 | Re: Migrate postgres databases from SQL_ASCII to UNICODE encoding |
| Previous Message | Kris Jurka | 2004-07-17 07:44:24 | Re: patch: fix hopelessly broken decodeUTF8() method |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-07-17 21:18:16 | Re: Migrate postgres databases from SQL_ASCII to UNICODE encoding |
| Previous Message | Gaetano Mendola | 2004-07-17 09:49:08 | Re: FOR-IN-EXECUTE, why fail? |