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
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 |