From: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: case sensitive/insensitive confusion |
Date: | 2005-02-01 11:44:13 |
Message-ID: | 41FF6B8D.E1010AEA@rodos.fzk.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Peter Eisentraut wrote:
>
> 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/
>
Under hpux I see
pg_controldata $PGDATA
...
LC_COLLATE: C
LC_CTYPE: C
Under linux I see
pg_controldata $PGDATA
...
LC_COLLATE: en_US
LC_CTYPE: en_US
That explains the confusion, even to me.
Thanx to Peter for the quick reply.
Regards, Christoph
From | Date | Subject | |
---|---|---|---|
Next Message | Theodore Petrosky | 2005-02-01 12:48:57 | Re: case sensitive/insensitive confusion |
Previous Message | Sean Davis | 2005-02-01 11:38:05 | Re: [SQL] OFFSET impact on Performance??? |