Re: problem with ORDER BY

Martijn van Oosterhout <kleptog@svana.org> writes:

> On Fri, Feb 01, 2008 at 11:06:07AM +0100, Nicolas KOWALSKI wrote:
>>
>> I do not understand why the following ORDER BY statment does not work
>> as I would expect:
>>
>> 3) When I want to sort them, I get this "strange" ordering:
>
> Show us your collation order:
> show lc_collate;

Here it is:

mon=> show lc_collate;
 lc_collate
-------------
 en_US.UTF-8
(1 row)

Thanks,
--
Nicolas