Re: case sensitive/insensitive confusion

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