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

Re: utf8 database not dumping utf8 characters

From: Scott Whitney <scott(at)journyx(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:04:44
Message-ID: 5eb9195d-5803-46b1-a388-fffd7550f5a7@zimbra.int.journyx.com (view raw or flat)
Thread:
Lists: pgsql-admin
What version, Matt? I had that problem back in 8.1x 

----- Original Message -----

> 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)

In response to

Responses

pgsql-admin by date

Next:From: Matt WilliamsDate: 2012-04-06 20:10:46
Subject: Re: utf8 database not dumping utf8 characters
Previous:From: Steve CrawfordDate: 2012-04-06 20:03:58
Subject: Re: utf8 database not dumping utf8 characters

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