Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE

From: "Andrew Lazarus" <drlaz(at)attglobal(dot)net>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE
Date: 2004-07-18 02:00:38
Message-ID: 075c01c46c6b$059ef320$847ba8c0@ANDYXP
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc pgsql-sql

If you pg_dump in ASCII format, could you figure out what has happened to
the 8-bit characters, if they are recognizable garbage (not truncated to
some genuine character) you then write a sed script. It by hand, but it
doesn't sound terrible.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-07-18 05:04:43 Re: [HACKERS] Point in Time Recovery
Previous Message Dario V. Fassi 2004-07-17 23:34:14 Re: Migrate postgres databases from SQL_ASCII to UNICODE

Browse pgsql-jdbc by date

  From Date Subject
Next Message Blaine Simpson 2004-07-18 04:10:22 psql-like pure Java client
Previous Message Oliver Jowett 2004-07-18 01:21:40 Re: DatabaseMetada.supportOpenCursorsAcrossCommit() return

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-07-18 06:29:04 Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE
Previous Message Dario V. Fassi 2004-07-17 23:26:17 Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE