| 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: | Whole Thread | Raw Message | 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 |