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