Re: case sensitive/insensitive confusion - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: case sensitive/insensitive confusion
Date
Msg-id 200502011114.00969.peter_e@gmx.net
Whole thread Raw
In response to case sensitive/insensitive confusion  (Christoph Haller <ch@rodos.fzk.de>)
Responses Re: case sensitive/insensitive confusion
List pgsql-sql
Christoph Haller wrote:
> It seems to me under hpux the sort is done case sensitive,
> as would one expect on SQL_ASCII encoding, whereas
> under linux a case insensitive sort is done.

The sort order depends entirely on the locale that you specify to initdb 
(not the encoding).  Please check the documentation there.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: case sensitive/insensitive confusion
Next
From: Sean Davis
Date:
Subject: Re: [PERFORM] OFFSET impact on Performance???