Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 95BBB1BFF91D
	for <pgsql-admin@postgresql.org>; Fri,  6 Apr 2012 16:55:37 -0300 (ADT)
Received: from mail-ob0-f174.google.com ([209.85.214.174])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <matt@williams-tech.net>) id 1SGFFv-0004j3-CO
	for pgsql-admin@postgresql.org; Fri, 06 Apr 2012 19:55:36 +0000
Received: by obbtb18 with SMTP id tb18so3490264obb.19
	for <pgsql-admin@postgresql.org>; Fri, 06 Apr 2012 12:55:22 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=google.com; s=20120113;
	h=date:from:to:message-id:subject:x-mailer:mime-version:content-type
	:x-gm-message-state;
	bh=JJd01GgB5QPxBeHY5BN0OCssg0AstxdNbEPKwZoacBM=;
	b=EUXaLKHmxH+8cjDQVetGSI0qoQjlnVsxi0ayf/8Af/jD1qCI+c36zL0NWgTrAjYZs3
	ihJmrF5xJfRzxlz/cG7459U0DfSfUUa5tEG/0lv/FSII3EYXzLPB7koiSnNVKqSLpKNx
	M2IKPjw0GNT6qkD/jGMz8z0Jiwb9XES5flINpkEAyGmMy2OQo5d6ITJkQeHQlorv2bQ/
	C9J8znbo4MW+N2bzZmsrkg5jVEkfIOB8pHswy8SSqZ9XLZHgJIaYcYsKNw8F6cU0Lay9
	4rIIBFgT5VLRW/CpWiqcsMtAUCj/EnX47bSsTjf22f3ED4P7yg2BcOG/kMhPw36YAo9p
	5qXg==
Received: by 10.182.202.69 with SMTP id kg5mr10951044obc.35.1333742121836;
	Fri, 06 Apr 2012 12:55:21 -0700 (PDT)
Received: from Macs-MacBook-Pro.local
	(h254.124.149.24.cable.rstb.jetbroadband.com. [24.149.124.254])
	by mx.google.com with ESMTPS id d9sm8161343obq.0.2012.04.06.12.55.21
	(version=TLSv1/SSLv3 cipher=OTHER);
	Fri, 06 Apr 2012 12:55:21 -0700 (PDT)
Date: Fri, 6 Apr 2012 15:55:19 -0400
From: Matt Williams <matt@williams-tech.net>
To: pgsql-admin@postgresql.org
Message-ID: <5D15382C1CF943D8A7B69D102A2BCBD4@williams-tech.net>
Subject: utf8 database not dumping utf8 characters
X-Mailer: sparrow 1.5 (build 1043)
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="4f7f4a27_7055a5f5_f71e"
X-Gm-Message-State: 
 ALoCoQlIVATdYW1KEZKYkx5UFzUABsiWUnFOQulSqVWfPlo1Ai+pq6MK0nlgwf6BH08MVAsFMAX8
X-Pg-Spam-Score: -2.0 (--)
X-Archive-Number: 201204/21
X-Sequence-Number: 39357

--4f7f4a27_7055a5f5_f71e
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

I have a database that is utf8 and displays utf8 values correctly in psql=
. When dumped, it displays the utf8 characters incorrectly. ie. =C3=B6 tu=
rns into =C3=83

In the header of the dump file, I have:

SET client=5Fencoding =3D 'UT=468';

So I'm not sure where the disconnect is=3F

Thoughts=3F

Thanks, =20

-- =20
Matt Williams
Sent with Sparrow (http://www.sparrowmailapp.com/=3Fsig)


--4f7f4a27_7055a5f5_f71e
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline


                <div>I have a database that is utf8 and displays utf8 val=
ues correctly in psql. When dumped, it displays the utf8 characters incor=
rectly. ie.&nbsp;<span style=3D=22font-size: 13px; =22>=C3=B6 turns into&=
nbsp;</span><span style=3D=22font-size: 13px; =22>=C3=83</span></div><div=
><span style=3D=22font-size: 13px; =22><br></span></div><div><span style=3D=
=22font-size: 13px; =22>In the header of the dump file, I have:</span></d=
iv><div><span style=3D=22font-size: 13px; =22><br></span></div><div><span=
 style=3D=22font-size: 13px; =22>SET client=5Fencoding =3D 'UT=468';</spa=
n></div><div><span style=3D=22font-size: 13px; =22><br></span></div><div>=
<font size=3D=223=22>So I'm not sure where the disconnect is=3F</font></d=
iv><div><font size=3D=223=22><br></font></div><div><font size=3D=223=22>T=
houghts=3F</font></div><div><font size=3D=223=22><br></font></div><div><f=
ont size=3D=223=22>Thanks,</font></div>
                <div><div><br></div><div>--&nbsp;</div><div>Matt Williams=
</div><div>Sent with <a href=3D=22http://www.sparrowmailapp.com/=3Fsig=22=
>Sparrow</a></div><div><br></div></div>
            
--4f7f4a27_7055a5f5_f71e--