Re: BUG #15651: Collation setting en_US.utf8 breaking sort order - Mailing list 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