Re: illegal sort order

Bruno Wolff III <bruno(at)wolff(dot)to> writes:
> Andrus <eetasoft(at)online(dot)ee> wrote:
>> SHOW ALL command returns the following:
>>
>> "client_encoding";"UNICODE"
>> "lc_collate";"Estonian_Estonia.1257"
>> "lc_ctype";"Estonian_Estonia.1257"
>> "lc_messages";"Estonian_Estonia.1257"
>> "lc_monetary";"Estonian_Estonia.1257"
>> "lc_numeric";"Estonian_Estonia.1257"
>> "lc_time";"Estonian_Estonia.1257"

> Are you running this on Windows? There is a problem with Unicode there.

Windows or not, the locale name suggests *very* strongly that it is not
a Unicode-using locale. If the database encoding doesn't match what the
locale is expecting then strange sort order is exactly what you are
likely to get.

We should defend against these sorts of configuration problems more
thoroughly, but it seems to be hard in general to determine what
character set a locale is actually using :-(

regards, tom lane