I'm not sure this is true. As far as the system is concerned this is
the correct ordering. ;) If you don't want collation based on your locale
I'd suggest either turning off locale in postgres (see configure
options) or initdb in "C" locale, you don't need to change the system's
collation to do this, just set the locale for the shell that runs initdb.
I'll try it. Maybe there should be a note in the postgresql documentation,
for people like me. >:-))
There's been talk about implementing the full SQL character set stuff in
the future which would probably at least limit these problems probably
(it would for example presumably allow you to collate a field you didn't
want to collate via hungarian rules by a different collation).
That would be nice.
Once again, the day is saved, thanks to the Postgresql Team. :-)
Bye,
Vig Sandor
