Re: unexpected (to me) sorting order

Поиск
Список
Период
Сортировка
Искать
От
Björn Lundin
Тема
Re: unexpected (to me) sorting order
Дата
Msg-id
5524F8BF.60608@gmail.com
Ответ на
Список
Дерево обсуждения
unexpected (to me) sorting order Björn Lundin <b.f.lundin@gmail.com>
Re: unexpected (to me) sorting order Chris Mair <chris@1006.org>
Re: unexpected (to me) sorting order Alberto Cabello Sánchez <alberto@unex.es>
Re: unexpected (to me) sorting order Björn Lundin <b.f.lundin@gmail.com>
Re: unexpected (to me) sorting order Glyn Astill <glynastill@yahoo.co.uk>
Re: unexpected (to me) sorting order Björn Lundin <b.f.lundin@gmail.com>
Re: unexpected (to me) sorting order Glyn Astill <glynastill@yahoo.co.uk>
Re: unexpected (to me) sorting order Björn Lundin <b.f.lundin@gmail.com>
Re: unexpected (to me) sorting order Scott Marlowe <scott.marlowe@gmail.com>
Re: unexpected (to me) sorting order Glyn Astill <glynastill@yahoo.co.uk>
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 по дате отправления
От: Chris Mair
Дата:
От: Björn Lundin
Дата:
FAQ