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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

  From Date Subject
Next Message Matt Williams 2012-04-06 20:10:46 Re: utf8 database not dumping utf8 characters
Previous Message Steve Crawford 2012-04-06 20:03:58 Re: utf8 database not dumping utf8 characters