Re: LC_COLLATE=C not working - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: LC_COLLATE=C not working
Date
Msg-id Pine.LNX.4.44.0310031219190.2332-100000@peter.localdomain
Whole thread Raw
In response to LC_COLLATE=C not working  ("Robert Wille" <vmg2rad02@sneakemail.com>)
List pgsql-general
Robert Wille writes:

> I have tried to do the same on my production server, and when I do the
> initdb, it says that LC_COLLATE is C, but it does not sort the same as
> the test server. Namely, on the test server 'z' < '~' and on the
> production server 'z' > '~'.

You probably still have LC_ALL set to something else.  LC_ALL overrides
LC_COLLATE and friends, which in turn override LANG.

--
Peter Eisentraut   peter_e@gmx.net


pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Type of application that use PostgreSQL
Next
From: Mike Mascari
Date:
Subject: Re: Type of application that use PostgreSQL