Re: utf8 database not dumping utf8 characters

From: Matt Williams <matt(at)williams-tech(dot)net>
To: Scott Whitney <swhitney(at)journyx(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: utf8 database not dumping utf8 characters
Date: 2012-04-06 20:11:07
Message-ID: 4AB3A16979104BD6BAE069C3D2F28602@williams-tech.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Crawford 2012-04-06 22:19:27 Re: utf8 database not dumping utf8 characters
Previous Message Matt Williams 2012-04-06 20:10:46 Re: utf8 database not dumping utf8 characters