Re: unexpected (to me) sorting order

Поиск
Список
Период
Сортировка
От Björn Lundin
Тема Re: unexpected (to me) sorting order
Дата
Msg-id 5524F8BF.60608@gmail.com
обсуждение исходный текст
Ответ на Re: unexpected (to me) sorting order  (Glyn Astill <glynastill@yahoo.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: Chris Mair
Дата:
Сообщение: Re: unexpected (to me) sorting order
Следующее
От: Björn Lundin
Дата:
Сообщение: Re: unexpected (to me) sorting order