Re: case sensitive/insensitive confusion

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: case sensitive/insensitive confusion
Date: 2005-02-01 10:14:00
Message-ID: 200502011114.00969.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Sean Davis 2005-02-01 11:38:05 Re: [SQL] OFFSET impact on Performance???
Previous Message Christoph Haller 2005-02-01 09:50:06 case sensitive/insensitive confusion