Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: LC_COLLATE=C not working
Date
Msg-id 22023.1065195337@sss.pgh.pa.us
Whole thread Raw
In response to Re: LC_COLLATE=C not working  ("Robert Wille" <vmg2rad02@sneakemail.com>)
List pgsql-general
Tree view 
"Robert Wille" <vmg2rad02@sneakemail.com> writes:
>> You probably still have LC_ALL set to something else.  LC_ALL overrides
>> LC_COLLATE and friends, which in turn override LANG.

> Nope. Any other ideas?

Please use pg_controldata to verify the LC_ settings on both databases.
I suspect they are not really both C.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: book on advanced postgresql?
Next
From: Shridhar Daithankar
Date:
Subject: Re: Server recommendations