Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tsfl9-004Nmz-RZ
	for pgsql-general@arkaria.postgresql.org; Thu, 13 Mar 2025 10:25:51 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tsfl7-00A2S7-Sc
	for pgsql-general@arkaria.postgresql.org; Thu, 13 Mar 2025 10:25:49 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <xof@thebuild.com>)
	id 1tsfl7-00A2Rx-HT
	for pgsql-general@lists.postgresql.org; Thu, 13 Mar 2025 10:25:49 +0000
Received: from smtp71.iad3b.emailsrvr.com ([146.20.161.71])
	by magus.postgresql.org with esmtps  (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <xof@thebuild.com>)
	id 1tsfl3-002dFj-2J
	for pgsql-general@lists.postgresql.org;
	Thu, 13 Mar 2025 10:25:49 +0000
X-Auth-ID: xof@thebuild.com
Received: by smtp9.relay.iad3b.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id E05EA20117;
	Thu, 13 Mar 2025 06:25:43 -0400 (EDT)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.1\))
Subject: Re: Moving from Linux to Linux?
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <6C78D9E9-2EC3-4FBF-AC22-268DCE8F6A91@gmail.com>
Date: Thu, 13 Mar 2025 10:25:12 +0000
Cc: Joe Conway <mail@joeconway.com>,
 Adrian Klaver <adrian.klaver@aklaver.com>,
 Pgsql-General List <pgsql-general@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <7EDFB0C6-3493-4066-90FF-F99C9707B272@thebuild.com>
References: <6E6059F6-E5A1-4A8D-8A5E-A41B921BBE67@gmail.com>
 <E0EC05FB-783D-4A24-81B9-0C345A5EC45A@gmail.com>
 <9a8d92de-228c-43b0-b66c-c3390b41044a@aklaver.com>
 <B6135108-EA9F-4E75-80EE-1077D0909F00@gmail.com>
 <c60b0558-290b-4fe8-b839-6a7725c980b3@joeconway.com>
 <6C78D9E9-2EC3-4FBF-AC22-268DCE8F6A91@gmail.com>
To: Paul Foerster <paul.foerster@gmail.com>
X-Mailer: Apple Mail (2.3776.700.51.11.1)
X-Classification-ID: 0a615c7f-b421-43c4-b95e-814740b0442c-1-1
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/7EDFB0C6-3493-4066-90FF-F99C9707B272%40thebuild.com>
Precedence: bulk



> On Mar 13, 2025, at 10:10, Paul Foerster <paul.foerster@gmail.com> =
wrote:
>=20
> 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.=