Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pae2b-00036o-Uk for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Mar 2023 14:48:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pae2Z-0007cy-Sm for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Mar 2023 14:48:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pae2Y-0007co-Rh for pgsql-hackers@lists.postgresql.org; Fri, 10 Mar 2023 14:48:15 +0000 Received: from new4-smtp.messagingengine.com ([66.111.4.230]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pae2V-0000SS-1V for pgsql-hackers@postgresql.org; Fri, 10 Mar 2023 14:48:14 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailnew.nyi.internal (Postfix) with ESMTP id 2B54C5820E7; Fri, 10 Mar 2023 09:48:09 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Fri, 10 Mar 2023 09:48:09 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1678459689; x= 1678466889; bh=r7i0zGnb3oIAILpUl9sm2DUMB8AaRMAJcJTDAPyC6fY=; b=P YtQhOGdvGzcEtShw4mLYgqI0v2yyekGqJ/AR4fGcB8B7KozyLKxBN9DZzw9MV9D1 dJqEuBqp31RxH4PDgBxsugxG2GeibQyw+L8YDdnAURgV87OmehehQeumF/Q31Nf6 APc6hWLXxuVfPUdO8xOtFYtqGebLlnPFdPolvnk2mi39hIcA8850aaXFGoRh+fxm nxVEb1GDG8MzEEv7cLkbJH2tjDCjFrYWfij7UmwwLYAnAmyG8mZY36Gc89SHFpmx RE1ayNao7GOStb4cWFfArvg9T63UxlZLKvuk8WN7DIUGXoKJpqVukIsyyHHfr7Q2 sxlX1n9TRwvnsG3wzodlg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrvddukedgieejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpefkffggfgfuvfhfhfgjtgfgsehtke ertddtfeejnecuhfhrohhmpefrvghtvghrucfgihhsvghnthhrrghuthcuoehpvghtvghr rdgvihhsvghnthhrrghuthesvghnthgvrhhprhhishgvuggsrdgtohhmqeenucggtffrrg htthgvrhhnpeelgfetfeeitdelleeggeejvefhueetfedvtdejheevueeifeegvdfhueel udetueenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpe hpvghtvghrrdgvihhsvghnthhrrghuthesvghnthgvrhhprhhishgvuggsrdgtohhm X-ME-Proxy: Feedback-ID: i131946ab:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 10 Mar 2023 09:48:08 -0500 (EST) Message-ID: Date: Fri, 10 Mar 2023 15:48:07 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.8.0 Subject: Re: pgsql: Use ICU by default at initdb time. Content-Language: en-US To: Jeff Davis , pgsql-hackers References: From: Peter Eisentraut In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10.03.23 15:38, Jeff Davis wrote: > On Fri, 2023-03-10 at 10:59 +0100, Peter Eisentraut wrote: >> I think originally the locale forced the encoding.  With ICU, we have >> a >> choice.  We could either stick to the encoding suggested by the OS, >> or >> pick our own. > > We still need LC_COLLATE and LC_CTYPE to match the database encoding > though. If we get those from the environment (which are connected to an > encoding), then I think we need to get the encoding from the > environment, too, right? Yes, of course. So we can't really do what I was thinking of.