From: Matt Williams <matt@williams-tech.net>
To: Scott Whitney <swhitney@journyx.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: utf8 database not dumping utf8 characters
Date: Fri, 6 Apr 2012 16:11:07 -0400
Message-ID: <4AB3A16979104BD6BAE069C3D2F28602@williams-tech.net> (raw)
In-Reply-To: <5eb9195d-5803-46b1-a388-fffd7550f5a7@zimbra.int.journyx.com>
References: <5eb9195d-5803-46b1-a388-fffd7550f5a7@zimbra.int.journyx.com>
version 9.1
--
Matt Williams
Sent with Sparrow (http://www.sparrowmailapp.com/?sig)
On Friday, April 6, 2012 at 4:04 PM, Scott Whitney wrote:
> What version, Matt? I had that problem back in 8.1x
>
> > I have a database that is utf8 and displays utf8 values correctly in psql. When dumped, it displays the utf8 characters incorrectly. ie. ö turns into Ã
> >
> > In the header of the dump file, I have:
> >
> > SET client_encoding = 'UTF8';
> >
> > So I'm not sure where the disconnect is?
> >
> > Thoughts?
> >
> > Thanks,
> >
> > --
> > Matt Williams
> > Sent with Sparrow (http://www.sparrowmailapp.com/?sig)
> >
>
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: matt@williams-tech.net, swhitney@journyx.com
Subject: Re: utf8 database not dumping utf8 characters
In-Reply-To: <4AB3A16979104BD6BAE069C3D2F28602@williams-tech.net>
* 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