Mixed UTF8 / Latin1 database

From: Claudio Cicali <c(dot)cicali(at)mclink(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Mixed UTF8 / Latin1 database
Date: 2004-04-16 12:38:33
Message-ID: 407FD3C9.6000006@mclink.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm trying to restore a pg_dump-backed up database from one
server to another. The problem is that the db is "mixed encoded"
in UTF-8 and LATIN1... (weird but, yes it is ! It was ported once
from a hypersonic db... that screwed up something and now I'm
fighting with that...).

So, trying to restore that db into a UTF-8 encoded new one, gives
me errors ("invalid unicode character..."), but importing it
into a LATIN1 econcoded one, gives me weird characters (of course).

I'm wondering if anyone could have a script or something to help me
with this situation... :(

thanks.

--
Claudio Cicali
c(dot)cicali(at)mclink(dot)it
http://www.flexer.it
GPG Key Fingerprint = 2E12 64D5 E5F5 2883 0472 4CFF 3682 E786 555D 25CE

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Sidney-Woollett 2004-04-16 13:51:09 Indexing null dates
Previous Message Andrew Sullivan 2004-04-16 12:17:11 Re: Mirroring tables from Oracle to Postgresql