Re: LC_COLLATE=C not working

From: "Robert Wille" <vmg2rad02(at)sneakemail(dot)com>
To: "Peter Eisentraut peter_e-at-gmx(dot)net |Postgres|" <4628hm6fbl0t(at)sneakemail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: LC_COLLATE=C not working
Date: 2003-10-03 13:36:49
Message-ID: 397d01c389b3$68b32cb0$6402a8c0@zucchini
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net
>
Nope. Any other ideas?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-10-03 13:52:07 Re: book on advanced postgresql?
Previous Message John Wells 2003-10-03 12:58:16 book on advanced postgresql?