Re: [SQL] case sensitive/insensitive confusion

2005-02-01 Thread Peter Eisentraut
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

Re: [SQL] case sensitive/insensitive confusion

2005-02-01 Thread Christoph Haller
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

Re: [SQL] case sensitive/insensitive confusion

2005-02-01 Thread Theodore Petrosky
I seem to have a problem with controlling the locale. Mac os x, postgresql 8.0.1 ./configure --with-rendezvous --enable-thread-safety --enable-locale but when I try: initdb --locale=es_ES ~/testdb I get: The files belonging to this database system will be owned by user postgres. This user

Re: [SQL] case sensitive/insensitive confusion

2005-02-01 Thread Tom Lane
Theodore Petrosky [EMAIL PROTECTED] writes: Mac os x, postgresql 8.0.1 initdb --locale=es_ES ~/testdb ... The database cluster will be initialized with locale es_ES. initdb: could not find suitable encoding for locale es_ES Rerun initdb with the -E option. I looked into this and find that