Re: BUG #15651: Collation setting en_US.utf8 breaking sort order

Поиск
Список
Период
Сортировка
От Daniel Verite
Тема Re: BUG #15651: Collation setting en_US.utf8 breaking sort order
Дата
Msg-id 9cbd8ba7-899f-4ed3-92b1-902b0d2456ae@manitou-mail.org
обсуждение исходный текст
Ответ на Re: BUG #15651: Collation setting en_US.utf8 breaking sort order  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-bugs
    Peter Eisentraut wrote:

> With ICU (COLLATE "und-x-icu"), I get the line with the space first.  I
> took a bit of a look around the various Unicode documents and I don't
> find anything that would defend the glibc behavior.

The glibc result is now version-dependent. With glibc-2.28,
on Debian buster:

  buster$ LC_COLLATE=en_US.utf8 sort stuff.txt

  ~!@#$^&(
  AAA
  BAA
  CAA

  buster$ apt-cache show libc-bin | grep Version
  Version: 2.28-7

As opposed to the current Debian stable, with glibc-2.24:

  stretch$ LC_COLLATE=en_US.utf8 sort stuff.txt
  ~!@#$^&(

  AAA
  BAA
  CAA
  DAA

  stretch$ apt-cache show libc-bin|grep Version
  Version: 2.24-11+deb9u3


Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: BUG #15651: Collation setting en_US.utf8 breaking sort order
Следующее
От: "Daniel Verite"
Дата:
Сообщение: RE: BUG #15651: Collation setting en_US.utf8 breaking sort order