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

Re: utf8 database not dumping utf8 characters

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Matt Williams <matt(at)williams-tech(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: utf8 database not dumping utf8 characters
Date: 2012-04-06 20:03:58
Message-ID: 4F7F4C2E.7050007@pinpointresearch.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

Responses

pgsql-admin by date

Next:From: Scott WhitneyDate: 2012-04-06 20:04:44
Subject: Re: utf8 database not dumping utf8 characters
Previous:From: Matt WilliamsDate: 2012-04-06 19:55:19
Subject: utf8 database not dumping utf8 characters

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