Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id BF742635EE4
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon,  7 Dec 2009 13:13:00 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 92304-04 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon,  7 Dec 2009 17:12:53 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-bw0-f213.google.com (mail-bw0-f213.google.com
	[209.85.218.213])
	by mail.postgresql.org (Postfix) with ESMTP id E1BEB632E76
	for <pgsql-sql@postgresql.org>; Mon,  7 Dec 2009 13:12:52 -0400 (AST)
Received: by bwz5 with SMTP id 5so3679575bwz.3
	for <pgsql-sql@postgresql.org>; Mon, 07 Dec 2009 09:12:51 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:message-id:subject
	:from:to:content-type;
	bh=xv7GA4Uv+sR+OzilPe5MSX4Y0sjUm66iDN5rOQFnLXo=;
	b=fD68GTUo0kucgEK7y4g3iDg/zBUcu9cO8xWEjkyPWD9awqdeAdjHaDZ3tISlJwCoXD
	lu9JZmUvqJPgPl/K2Be2fqnlDdPbyFwWOaEZeet0clp6qluH2WaUdgM+ocfCb3uKXiv2
	kJYfxsEaPaBpksqAzUN2v67B4mhxaMYKyg764=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=gRGa7NVhsTuk85cIqzCTdLrVIBAGHR7g4EmyJLINJS+YzPRGkLmDPEwXLkx3eSh6rl
	gEgocwWdzrjNqMUayvvPy+wZLTbpi/GHGqLmZGkdZ/5DAl7XlLCAstTdymL3CsuQoHCH
	UJyCgRI/DZgzWYxkbICu/fbgFSsGaTv7O920E=
MIME-Version: 1.0
Received: by 10.204.25.71 with SMTP id y7mr1708563bkb.67.1260205971299; Mon,
	07 Dec 2009 09:12:51 -0800 (PST)
Date: Mon, 7 Dec 2009 12:12:51 -0500
Message-ID: <22431f1b0912070912p10c3191flaab6cee97e5ab63f@mail.gmail.com>
Subject: problems with changing the case of turkish characters
From: the6campbells <the6campbells@gmail.com>
To: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=0003255596b2435dcf047a269178
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.109 tagged_above=-10 required=5
	tests=BAYES_05=-1.11, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200912/15
X-Sequence-Number: 33453

--0003255596b2435dcf047a269178
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Just want to clarify if there is something I've overlooked or if this is a
known issue in PG 8.4 and 8.3


CREATE DATABASE test
  WITH OWNER =3D postgres
       ENCODING =3D 'UTF8'
       LC_COLLATE =3D 'English, United States, UTF-8'
       LC_CTYPE =3D 'English, United States, UTF-8'


select ('=C4=B0ste=C4=9Fi') from tversion
"=C4=B0ste=C4=9Fi" was expecting "iste=C4=9Fi"

select upper('i=C4=B1=C5=9F=C4=9F=C3=BC=C3=A7=C3=B6') from tversion
"I=C4=B1=C5=9E=C4=9E=C3=9C=C3=87=C3=96"

select lower ('=C4=B0I=C5=9E=C4=9E=C3=9C=C3=87=C3=96') from tversion
"=C4=B0i=C5=9F=C4=9F=C3=BC=C3=A7=C3=B6"

--0003255596b2435dcf047a269178
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div>Just want to clarify if there is something I&#39;ve overlooked or if t=
his is a known issue in PG 8.4 and 8.3</div>
<div>=C2=A0</div>
<div>=C2=A0</div>
<div>CREATE DATABASE test<br>=C2=A0 WITH OWNER =3D postgres<br>=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0 ENCODING =3D &#39;UTF8&#39;<br>=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0 LC_COLLATE =3D &#39;English, United States, UTF-8&#39;<b=
r>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 LC_CTYPE =3D &#39;English, United St=
ates, UTF-8&#39;</div>
<div>=C2=A0</div>
<div>=C2=A0</div>
<div>select (&#39;=C4=B0ste=C4=9Fi&#39;) from tversion<br>&quot;=C4=B0ste=
=C4=9Fi&quot; was expecting &quot;iste=C4=9Fi&quot;</div>
<div>=C2=A0</div>
<div>select upper(&#39;i=C4=B1=C5=9F=C4=9F=C3=BC=C3=A7=C3=B6&#39;) from tve=
rsion</div>
<div>&quot;I=C4=B1=C5=9E=C4=9E=C3=9C=C3=87=C3=96&quot;</div>
<div>=C2=A0</div>
<div>select lower (&#39;=C4=B0I=C5=9E=C4=9E=C3=9C=C3=87=C3=96&#39;) from tv=
ersion</div>
<div>&quot;=C4=B0i=C5=9F=C4=9F=C3=BC=C3=A7=C3=B6&quot;</div>
<div>=C2=A0</div>
<div>=C2=A0</div>

--0003255596b2435dcf047a269178--