Re: LC_COLLATE=C not working

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Robert Wille" <vmg2rad02(at)sneakemail(dot)com>
Cc: "Peter Eisentraut peter_e-at-gmx(dot)net |Postgres|" <4628hm6fbl0t(at)sneakemail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: LC_COLLATE=C not working
Date: 2003-10-03 15:35:37
Message-ID: 22023.1065195337@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Robert Wille" <vmg2rad02(at)sneakemail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-10-03 15:37:43 Re: Server recommendations
Previous Message Christopher Browne 2003-10-03 15:28:20 Re: migrate from postgres to mysql