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)
Список
Дерево обсуждения
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 по дате отправления