Re: LC_COLLATE=C not working

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Robert Wille <vmg2rad02(at)sneakemail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: LC_COLLATE=C not working
Date: 2003-10-03 10:20:03
Message-ID: Pine.LNX.4.44.0310031219190.2332-100000@peter.localdomain
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 2003-10-03 10:32:03 Re: Type of application that use PostgreSQL
Previous Message Shridhar Daithankar 2003-10-03 09:26:15 Re: Type of application that use PostgreSQL