Re: utf8 database not dumping utf8 characters - Mailing list pgsql-admin

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)