Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 55F29633557
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon,  7 Dec 2009 17:21:16 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 02083-01-4 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon,  7 Dec 2009 21:21:00 +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 5810D640F0E
	for <pgsql-sql@postgresql.org>; Mon,  7 Dec 2009 17:20:28 -0400 (AST)
Received: by bwz5 with SMTP id 5so3915518bwz.3
	for <pgsql-sql@postgresql.org>; Mon, 07 Dec 2009 13:20:26 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=XyN+gLSqS+P8KjX231PLhp6T1u3XRtDEhA1J+Otr03M=;
	b=qSa3647oDlNZVLGtlikvXWzTmZyj7F0bSqiC3dAiAjeWEs4MwyDsf/hUiOcvu6GOgj
	r/5/55R16rUB1X+nhC/X6kWo0YfHveEpiNeiRiNkBxm8xaCrpiMTgQEhfizv24wpZjA0
	0M0Eh+3797jtjkR0rmHGPN+hvR5of1aOZdQvU=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=SF4JbwEXm0ldbNb+rHGHA4Bv1szFICelbS+BsqJXt+N6N3IpXRS4d1jOPo0HxIC9os
	RqfjX5O1g+9wSwxVS7DpuiL3sE56KMnSNItElvZhnv+TBEOwHQu6vkHAxbCcXAYuiUUZ
	fgXwKeBbaSBW/TtHSIFN2AoQdByjXh7zjemfM=
MIME-Version: 1.0
Received: by 10.204.26.147 with SMTP id e19mr7707078bkc.149.1260220826540;
	Mon, 07 Dec 2009 13:20:26 -0800 (PST)
In-Reply-To: <6882.1260206888@sss.pgh.pa.us>
References: <22431f1b0912070912p10c3191flaab6cee97e5ab63f@mail.gmail.com>
	<6882.1260206888@sss.pgh.pa.us>
Date: Mon, 7 Dec 2009 16:20:26 -0500
Message-ID: <22431f1b0912071320i3adfede7qe6dc8b22f2ea0f4f@mail.gmail.com>
Subject: Re: problems with changing the case of turkish characters
From: the6campbells <the6campbells@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=000325557d26b45a9b047a2a067d
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.195 tagged_above=-10 required=5 tests=AWL=0.403,
	BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200912/17
X-Sequence-Number: 33455

--000325557d26b45a9b047a2a067d
Content-Type: text/plain; charset=ISO-8859-1

so where would I define something akin to what I can do in DB2 LUW where
collate using system means to sort by the codeset. ie. without english,
united states in LC_COLLATE.

USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM




On Mon, Dec 7, 2009 at 12:28 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> the6campbells <the6campbells@gmail.com> writes:
> > 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 = postgres
> >        ENCODING = 'UTF8'
> >        LC_COLLATE = 'English, United States, UTF-8'
> >        LC_CTYPE = 'English, United States, UTF-8'
>
> Not sure why you'd be expecting an English locale to follow Turkish
> case-changing rules.
>
>                        regards, tom lane
>

--000325557d26b45a9b047a2a067d
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>so where would I define something akin to what I can do in DB2 LUW whe=
re collate using system means to sort by the codeset. ie. without english, =
united states in LC_COLLATE. </div>
<div>=A0</div>
<div>USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM</div>
<div>=A0</div>
<div><br><br>=A0</div>
<div class=3D"gmail_quote">On Mon, Dec 7, 2009 at 12:28 PM, Tom Lane <span =
dir=3D"ltr">&lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&=
gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div class=3D"im">the6campbells &lt;<a href=3D"mailto:the6campbells@gmail.c=
om">the6campbells@gmail.com</a>&gt; writes:<br>&gt; Just want to clarify if=
 there is something I&#39;ve overlooked or if this is a<br>&gt; known issue=
 in PG 8.4 and 8.3<br>
<br>&gt; CREATE DATABASE test<br>&gt; =A0 WITH OWNER =3D postgres<br>&gt; =
=A0 =A0 =A0 =A0ENCODING =3D &#39;UTF8&#39;<br>&gt; =A0 =A0 =A0 =A0LC_COLLAT=
E =3D &#39;English, United States, UTF-8&#39;<br>&gt; =A0 =A0 =A0 =A0LC_CTY=
PE =3D &#39;English, United States, UTF-8&#39;<br>
<br></div>Not sure why you&#39;d be expecting an English locale to follow T=
urkish<br>case-changing rules.<br><br>=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0regards, tom lane<br></blockquote></div><br>

--000325557d26b45a9b047a2a067d--