Re: Problem while ordering Turkish chars - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Problem while ordering Turkish chars
Date
Msg-id 21889.1050767355@sss.pgh.pa.us
Whole thread Raw
In response to Problem while ordering Turkish chars  (Devrim GUNDUZ <devrim@gunduz.org>)
List pgsql-hackers
Devrim GUNDUZ <devrim@gunduz.org> writes:
> Here is the locale setting:
> LC_MESSAGES = 'en_US'
> LC_MONETARY = 'en_US'
> LC_NUMERIC = 'en_US'
> LC_TIME = 'en_US'

> If I change it to tr_TR, nothing changes. 

LC_COLLATE is what determines sort order, and you can't change it on the
fly; it's determined at initdb time.  You'll need to re-initdb in tr_TR
locale.  (See pg_controldata printout.)
        regards, tom lane



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: For the ametures. (related to "Are we losing momentum?")
Next
From: Tom Lane
Date:
Subject: Re: Note about upcoming instability in FE/BE protocol