Re: unexpected (to me) sorting order - Mailing list pgsql-general

From Björn Lundin
Subject Re: unexpected (to me) sorting order
Date
Msg-id 5524F8BF.60608@gmail.com
Whole thread Raw
In response to Re: unexpected (to me) sorting order  (Glyn Astill <glynastill@yahoo.co.uk>)
List pgsql-general
On 2015-04-08 11:33, Glyn Astill wrote:

> The collation of your "bnl" database is utf8, so the "." punctuation
> character is seen as a "variable element" and given a lower weighting in
> the sort to the rest of the characters.  That's just how the collate
algorithm works in UTF8.
> Try with LC_COLLATE = 'C' and it should sort how you expect.
>

Ok.
And as Chris Mair says in his answer, it looks like the '.' is
ignored, and then I see the pattern
Thanks

--
Björn


pgsql-general by date:

Previous
From: Chris Mair
Date:
Subject: Re: unexpected (to me) sorting order
Next
From: Björn Lundin
Date:
Subject: Re: unexpected (to me) sorting order