Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id E2B6C1BFF91D for ; Fri, 6 Apr 2012 17:04:13 -0300 (ADT) Received: from cerberus.pinpointresearch.com ([66.7.238.130] helo=polaris.pinpointresearch.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SGFOF-0004og-49 for pgsql-admin@postgresql.org; Fri, 06 Apr 2012 20:04:12 +0000 Received: from betelgeuse.pinpointresearch.com (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id DA563E00EC82; Fri, 6 Apr 2012 13:03:56 -0700 (PDT) Message-ID: <4F7F4C2E.7050007@pinpointresearch.com> Date: Fri, 06 Apr 2012 13:03:58 -0700 From: Steve Crawford User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.27) Gecko/20120216 Lightning/1.0b2 Thunderbird/3.1.19 MIME-Version: 1.0 To: Matt Williams CC: pgsql-admin@postgresql.org Subject: Re: utf8 database not dumping utf8 characters References: <5D15382C1CF943D8A7B69D102A2BCBD4@williams-tech.net> In-Reply-To: <5D15382C1CF943D8A7B69D102A2BCBD4@williams-tech.net> Content-Type: multipart/alternative; boundary="------------000508060301000707050807" X-Pg-Spam-Score: -1.3 (-) X-Archive-Number: 201204/22 X-Sequence-Number: 39358 This is a multi-part message in MIME format. --------------000508060301000707050807 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable On 04/06/2012 12:55 PM, Matt Williams wrote: > I have a database that is utf8 and displays utf8 values correctly in=20 > psql. When dumped, it displays the utf8 characters incorrectly. ie. =C3= =B6=20 > turns into =C3=83 > > In the header of the dump file, I have: > > SET client_encoding =3D 'UTF8'; > > So I'm not sure where the disconnect is? > > Thoughts? > > Thanks, > > --=20 > Matt Williams > Sent with Sparrow > With what are you viewing the dump file and is everything in the chain=20 (terminal, less/vi/...) set to interpret/display that data as UTF8? You=20 can always use a hex-dump program to see the actual bytes in the file=20 and determine if they are what you expect for UTF8. Cheers, Steve --------------000508060301000707050807 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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.=C2=A0=C3=B6 tur= ns into=C2=A0=C3=83

In the header of the dump file, I have:

SET client_encoding =3D 'UTF8= ';

So I'm not sure where the disconnect is?

Thoughts?

Thanks,

--=C2=A0
Matt Williams
Sent with Sparrow

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

--------------000508060301000707050807--