Postgres Pro
Downloads
Home   >   mailing lists

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

From Scott Whitney
Subject Re: utf8 database not dumping utf8 characters
Date
Msg-id 5eb9195d-5803-46b1-a388-fffd7550f5a7@zimbra.int.journyx.com
Whole thread Raw
In response to utf8 database not dumping utf8 characters  (Matt Williams <matt@williams-tech.net>)
Responses Re: utf8 database not dumping utf8 characters  (Matt Williams <matt@williams-tech.net>)
List pgsql-admin
Tree view
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)


pgsql-admin by date:

Previous
From: Steve Crawford
Date:
Subject: Re: utf8 database not dumping utf8 characters
Next
From: Matt Williams
Date:
Subject: Re: utf8 database not dumping utf8 characters