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.96) (envelope-from ) id 1wrd36-0000uR-2q for pgsql-general@arkaria.postgresql.org; Wed, 05 Aug 2026 14:56:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wrd36-000OXN-0j for pgsql-general@arkaria.postgresql.org; Wed, 05 Aug 2026 14:56:51 +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.96) (envelope-from ) id 1wrd35-000OXF-2u for pgsql-general@lists.postgresql.org; Wed, 05 Aug 2026 14:56:51 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wrd32-00000000P6X-1hbu for pgsql-general@lists.postgresql.org; Wed, 05 Aug 2026 14:56:50 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.18.1/8.18.1) with ESMTP id 675EukAD1337862; Wed, 5 Aug 2026 10:56:46 -0400 From: Tom Lane To: "Zwettler Markus (OIZ)" cc: Adrian Klaver , "pgsql-general@lists.postgresql.org" Subject: Re: AW: [Extern] Re: ICU database? In-reply-to: References: <9905eca3-cb6d-4c8e-bfd6-1b620f18cc79@aklaver.com> Comments: In-reply-to "Zwettler Markus (OIZ)" message dated "Wed, 05 Aug 2026 14:48:45 -0000" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <1337860.1785941806.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Wed, 05 Aug 2026 10:56:46 -0400 Message-ID: <1337861.1785941806@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk "Zwettler Markus (OIZ)" writes: > Name |=C2=A0 Owner | Encoding | Locale Provider | Collate | Ctype | > Locale | ICU Rules |=C2=A0=C2=A0 Access privileges > = > -----------+----------+----------+-----------------+---------+------- > +-------------+-----------+----------------------- > = > eng001 | dbowner | UTF8 | icu | C | C | > de-CH-x-icu |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= | =3DCTc/dbowner + > = > |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 | > |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | dbowner=3D= CTc/dbowner I believe those columns reflect the libc locale settings that are being used. They don't affect behavior that is driven by ICU ... but not everything is. You would likely want to set LANG=3Dde_DE or the like during initdb, along with specifying the ICU locale. regards, tom lane