Skip site navigation (1) Skip section navigation (2)

utf8 database not dumping utf8 characters

From: Matt Williams <matt(at)williams-tech(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: utf8 database not dumping utf8 characters
Date: 2012-04-06 19:55:19
Message-ID: 5D15382C1CF943D8A7B69D102A2BCBD4@williams-tech.net (view raw or flat)
Thread:
Lists: pgsql-admin
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)

Responses

pgsql-admin by date

Next:From: Steve CrawfordDate: 2012-04-06 20:03:58
Subject: Re: utf8 database not dumping utf8 characters
Previous:From: Tom LaneDate: 2012-04-06 14:01:09
Subject: Re: replication failure with GIN index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group