Re: case-sensitive sorting and locale settings? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: case-sensitive sorting and locale settings?
Date
Msg-id Pine.LNX.4.44.0311101840310.11030-100000@peter.localdomain
Whole thread Raw
In response to case-sensitive sorting and locale settings?  (CSN <cool_screen_name90001@yahoo.com>)
List 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@gmx.net


pgsql-general by date:

Previous
From: Kathy Zhu
Date:
Subject: Re: SQL-question: returning the id of an insert querry
Next
From: "Paul R. Sand"
Date:
Subject: Visual C++ and Postgres