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

Ok so if this is intended behavior of UTF8 then I understand. My last question then would be if I use a collation setting of C, does it mean I won't be able to support multiple languages?

-----Original Message-----
From: Peter Geoghegan <pg(at)bowt(dot)ie>
Sent: Friday, February 22, 2019 1:41 PM
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Kaleb Akalework <kaleb(dot)akalework(at)asg(dot)com>; PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15651: Collation setting en_US.utf8 breaking sort order

*** External email: Verify sender before opening attachments or links ***

On Fri, Feb 22, 2019 at 10:03 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> This appears to be the intended behavior of en_US sorting.

Right. UCA style algorithms tend to give the least weight of all to whitespace characters. They're tertiary weight, if memory serves.

--
Peter Geoghegan