From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Mike Blackwell <maiku41(at)sbcglobal(dot)net> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Character encoding conversion |
Date: | 2008-02-09 18:14:35 |
Message-ID: | 25696.1202580875@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Mike Blackwell <maiku41(at)sbcglobal(dot)net> writes:
> I have a database which was originally created with LATIN1 encoding.
> I'd like to move it to UTF8. The data will load ok (COPY) but I am
> getting 'invalid byte sequence for encoding..." messages when accessing
> the data.
How exactly did you move the data? And what PG version are we talking
about?
> Is there a way to automatically convert the offending characters, or to
> easily locate them in a pg_dump file so they can be converted by hand?
If you've got client_encoding and server_encoding set up correctly,
it should happen automatically during the COPY. I think you messed
that up somehow, but it's not clear just how.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Dean Gibson (DB Administrator) | 2008-02-10 04:34:16 | When to ANALYZE w/ auto-vacuum |
Previous Message | Tom Lane | 2008-02-09 18:03:37 | Re: Postgres Backup and Restore |