Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-jdbcpgsql-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

pgsql-sql by date

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

pgsql-admin by date

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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group