Re: Is it bad sorting in UTF ?? - Mailing list pgsql-general

wstrzalka wrote:
> Why PG sort's my data in case insensitive manner?

> masterdb=# select name, setting from pg_settings WHERE name ilike 'lc
> %';
>     name     |   setting
> -------------+-------------
>  lc_collate  | en_US.UTF-8

Because that's what en_US.UTF-8 does. If you want "computer-style"
sorting choose the "C" locale. You'll need to dump all your databases an
re-initdb to do that I'm afraid. I believe 8.4 is going to allow
different locales for each database though.

--
   Richard Huxton
   Archonet Ltd