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

From Robert Wille
Subject Re: LC_COLLATE=C not working
Date
Msg-id 397d01c389b3$68b32cb0$6402a8c0@zucchini
Whole thread Raw
In response to Re: LC_COLLATE=C not working  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: LC_COLLATE=C not working  (Tom Lane <tgl@sss.pgh.pa.us>)
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
>
Nope. Any other ideas?

pgsql-general by date:

Previous
From: "John Wells"
Date:
Subject: book on advanced postgresql?
Next
From: Tom Lane
Date:
Subject: Re: book on advanced postgresql?