Re: Moving from Linux to Linux?

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Paul Foerster <paul(dot)foerster(at)gmail(dot)com>
Cc: Joe Conway <mail(at)joeconway(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Pgsql-General List <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Moving from Linux to Linux?
Date: 2025-03-13 10:25:12
Message-ID: 7EDFB0C6-3493-4066-90FF-F99C9707B272@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Mar 13, 2025, at 10:10, Paul Foerster <paul(dot)foerster(at)gmail(dot)com> wrote:
>
> Is C.UTF8 really the same as en_US.UTF8?

No. C.UTF8 sorts on Unicode code points, which will be (somewhat) different from en_US.UTF8.

If you want a collation that is "good enough" across multiple languages, the ICU collation und-x-icu is the best bet.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2025-03-13 11:20:46 Re: Finding execution time for a query
Previous Message Paul Foerster 2025-03-13 10:10:40 Re: Moving from Linux to Linux?