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 <t...@sss.pgh.pa.us> wrote: > the6campbells <the6campbe...@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 >
