Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id D58AD1BFF91D
	for <pgsql-admin@postgresql.org>; Fri,  6 Apr 2012 17:11:11 -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 1SGFUz-0004xh-Sh
	for pgsql-admin@postgresql.org; Fri, 06 Apr 2012 20:11:11 +0000
Received: by mail-ob0-f174.google.com with SMTP id tb18so3506048obb.19
	for <pgsql-admin@postgresql.org>; Fri, 06 Apr 2012 13:11:09 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=google.com; s=20120113;
	h=date:from:to:cc:message-id:in-reply-to:references:subject:x-mailer
	:mime-version:content-type:x-gm-message-state;
	bh=6D+/IAokBH6U+Kzz4WUJfiA+G1FE6WgOTqBlJPKB0oU=;
	b=UYkN95XSzIK97u4HMfhbdrGlawQj+iddibywUSnREEj+gVYr7mHsq37VeRwrfYQWp+
	tvGJcDNd/t0ccbPIUxJhckPieH0JDaTq2Ugb5GCFXn8Kl+E18CJrqCxljLcE5ZyAwYxw
	9vYrT5KfTYvrnasNAVgdWXEWWK5VaiH21XPuXUp5sWOmTthITxKNaeMvL8K4JsRbxFHr
	fGyypqtj9IYli6kZK+pB56dxByy3Dkfhlnga7+BUOHQ3D3coGKNuC5o18IrldrNEzidV
	WsB7NHrZ5kp2/Qh7tSwBUX8lWS5Rp0ZW2ZLrNXxdHrSNBylSM9NiL+tS7S6/1aDtpoVU
	1zWA==
Received: by 10.182.119.71 with SMTP id ks7mr11057508obb.9.1333743069407;
	Fri, 06 Apr 2012 13:11:09 -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 t1sm3779327obl.5.2012.04.06.13.11.08
	(version=TLSv1/SSLv3 cipher=OTHER);
	Fri, 06 Apr 2012 13:11:09 -0700 (PDT)
Date: Fri, 6 Apr 2012 16:11:07 -0400
From: Matt Williams <matt@williams-tech.net>
To: Scott Whitney <swhitney@journyx.com>
Cc: pgsql-admin@postgresql.org
Message-ID: <4AB3A16979104BD6BAE069C3D2F28602@williams-tech.net>
In-Reply-To: <5eb9195d-5803-46b1-a388-fffd7550f5a7@zimbra.int.journyx.com>
References: <5eb9195d-5803-46b1-a388-fffd7550f5a7@zimbra.int.journyx.com>
Subject: Re: utf8 database not dumping utf8 characters
X-Mailer: sparrow 1.5 (build 1043)
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="4f7f4ddb_6a3dd3e8_f71e"
X-Gm-Message-State: 
 ALoCoQlA+E1r1bpsS9p5TnQwV87bVqZzgdW9cvF7jld+3y/nv1BJZUgFklc/oLR7VWjhm1/kYn9v
X-Pg-Spam-Score: -2.0 (--)
X-Archive-Number: 201204/25
X-Sequence-Number: 39361

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

version 9.1 =20

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


On =46riday, April 6, 2012 at 4:04 PM, Scott Whitney wrote:

> What version, Matt=3F I had that problem back in 8.1x
> =20
> > 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=
 turns into =C3=83
> > =20
> > In the header of the dump file, I have:
> > =20
> > SET client=5Fencoding =3D 'UT=468';
> > =20
> > So I'm not sure where the disconnect is=3F
> > =20
> > Thoughts=3F
> > =20
> > Thanks,  =20
> > =20
> > --  =20
> > Matt Williams
> > Sent with Sparrow (http://www.sparrowmailapp.com/=3Fsig)
> > =20
> =20


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


                <div>version 9.1
                </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>
                =20
                <p style=3D=22color: =23A0A0A8;=22>On =46riday, April 6, =
2012 at 4:04 PM, Scott Whitney wrote:</p>
                <blockquote type=3D=22cite=22 style=3D=22border-left-styl=
e:solid;border-width:1px;margin-left:0px;padding-left:10px;=22>
                    <span><div><div><div style=3D=22font-family: Times Ne=
w Roman; font-size: 12pt; color: =23000000=22>What version, Matt=3F I had=
 that problem back in 8.1x<br><br><hr><blockquote type=3D=22cite=22><div>=
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<br><br>In the header of the dump file, I have:<br><br>SET=
 client=5Fencoding =3D 'UT=468';<br><br>So I'm not sure where the disconn=
ect is=3F<br><br>Thoughts=3F<br><br>Thanks, &nbsp;<br><br>-- &nbsp;<br>Ma=
tt Williams<br>Sent with Sparrow (<a href=3D=22http://www.sparrowmailapp.=
com/=3Fsig=22>http://www.sparrowmailapp.com/=3Fsig</a>)<br><br></div></bl=
ockquote><br></div></div></div></span>
                =20
                =20
                =20
                =20
                </blockquote>
                =20
                <div>
                    <br>
                </div>
            
--4f7f4ddb_6a3dd3e8_f71e--