Case sensitive order by - Mailing list pgsql-general

From Michaël Fiey
Subject Case sensitive order by
Date
Msg-id 004401c0d46f$9d2ffc80$6400a8c0@pc03
Whole thread Raw
Responses Re: Case sensitive order by  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

I have a problem with a case sensitive 'order by'.
On my development platform, the 'order by' clauses are insensitive
But on my production platform, they are case sensitive.
I did the same installation on both platforms, from RPMs I downloaded
(Postgresql 7.1  on Redhat 7.0).
I tried to set LC_COLLATE=C before initdb, but nothing changed.

Is there a configuration for that ? Is it a specific parameter on my system
?

Any help will be appreciated

Thank's a lot.




pgsql-general by date:

Previous
From: Tony Grant
Date:
Subject: Re: Invoices
Next
From: newsreader@mediaone.net
Date:
Subject: Re: a primer on trigger?