Re: problems with changing the case of turkish characters

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> the6campbells <the6campbells(at)gmail(dot)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
>