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