From: Steve Crawford <scrawford@pinpointresearch.com>
To: Matt Williams <matt@williams-tech.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: utf8 database not dumping utf8 characters
Date: Fri, 06 Apr 2012 13:03:58 -0700
Message-ID: <4F7F4C2E.7050007@pinpointresearch.com> (raw)
In-Reply-To: <5D15382C1CF943D8A7B69D102A2BCBD4@williams-tech.net>
References: <5D15382C1CF943D8A7B69D102A2BCBD4@williams-tech.net>
On 04/06/2012 12:55 PM, Matt Williams wrote:
> 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;
>
With what are you viewing the dump file and is everything in the chain
(terminal, less/vi/...) set to interpret/display that data as UTF8? You
can always use a hex-dump program to see the actual bytes in the file
and determine if they are what you expect for UTF8.
Cheers,
Steve
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: scrawford@pinpointresearch.com, matt@williams-tech.net
Subject: Re: utf8 database not dumping utf8 characters
In-Reply-To: <4F7F4C2E.7050007@pinpointresearch.com>
* 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