Re: [ADMIN] utf8 database not dumping utf8 characters

[Matt Williams]

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