From: Matt Williams <matt@williams-tech.net>
To: pgsql-admin@postgresql.org
Subject: utf8 database not dumping utf8 characters
Date: Fri, 6 Apr 2012 15:55:19 -0400
Message-ID: <5D15382C1CF943D8A7B69D102A2BCBD4@williams-tech.net> (raw)
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: matt@williams-tech.net
Subject: Re: utf8 database not dumping utf8 characters
In-Reply-To: <5D15382C1CF943D8A7B69D102A2BCBD4@williams-tech.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox