Re: case-sensitive sorting and locale settings?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: CSN <cool_screen_name90001(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: case-sensitive sorting and locale settings?
Date: 2003-11-10 17:41:22
Message-ID: Pine.LNX.4.44.0311101840310.11030-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

CSN writes:

> On my windows/cygwin/PG 7.3.1 box, results are sorted
> with lowercase appearing after uppercase. On my
> redhat/PG 7.3.3 boxes results are sorted without
> regard to case. Is there some locale (or other)
> setting that controls this? If so, which locales do
> which?

The first box apparently uses no locale (set to "C"), the second box uses
some locale (all locales behave that way).

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-11-10 17:56:06 Re: Temp rows - is it possible?
Previous Message Rajesh Kumar Mallah 2003-11-10 17:28:15 Re: Question on Select