Case sensitive order by

From: Michaël Fiey <m(dot)fiey(at)futuresoundtech(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Case sensitive order by
Date: 2001-05-04 07:55:40
Message-ID: 004401c0d46f$9d2ffc80$6400a8c0@pc03
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew McMillan 2001-05-04 08:07:44 Re: [NOVICE] Re: psql with PHP question
Previous Message Steve Ackerman 2001-05-04 07:51:36 RE: Ideal hardware configuration for pgsql

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeroen Habets 2001-05-04 10:34:29 RE: postgres jdbc source code
Previous Message Thomas Swan 2001-05-04 07:09:23 Re: New Linux xfs/reiser file systems