Re: Is it bad sorting in UTF ??

At 07:57 PM 4/14/2009, Richard Huxton wrote:
>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.

Is it possible to have something like:

select name from sometable order by collate(name,'en_US.UTF-8');
select name from sometable order by collate(name,'C');

Link.