From: Michael Fuhr <mike@fuhr.org>
To: Mike Blackwell <maiku41@sbcglobal.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Character encoding conversion
Date: Sat, 9 Feb 2008 07:46:50 -0700
Message-ID: <20080209144649.GA16941@winnie.fuhr.org> (raw)
In-Reply-To: <47ADB8AA.6070305@sbcglobal.net>
References: <47ADB8AA.6070305@sbcglobal.net>
On Sat, Feb 09, 2008 at 08:28:58AM -0600, Mike Blackwell wrote:
> 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.
What's the complete error message? What's the output of the following
query in a session that gets the error?
select name, setting from pg_settings where name ~ 'encoding';
> 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?
You said the data loaded without error, right? Let's see if we can
figure out why queries are failing before considering what corrective
action to take.
--
Michael Fuhr
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mike@fuhr.org, maiku41@sbcglobal.net
Subject: Re: Character encoding conversion
In-Reply-To: <20080209144649.GA16941@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox