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 1padt2-0002eN-9d for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Mar 2023 14:38:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1padt1-0000YH-4t for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Mar 2023 14:38:23 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1padt0-0000Y7-N6 for pgsql-hackers@lists.postgresql.org; Fri, 10 Mar 2023 14:38:22 +0000 Received: from mail-pl1-x62e.google.com ([2607:f8b0:4864:20::62e]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1padsy-0002Od-9m for pgsql-hackers@postgresql.org; Fri, 10 Mar 2023 14:38:21 +0000 Received: by mail-pl1-x62e.google.com with SMTP id h8so5748525plf.10 for ; Fri, 10 Mar 2023 06:38:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20210112.gappssmtp.com; s=20210112; t=1678459099; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=1ZlLtCFCU5tbP36r0gwBBDs0qxlmFt5WfMKO/PFuwD8=; b=AMjJMw6/FAc/tKe7Ccn4wXiMLSW9KYqEBg1NisSTmSJQzWkNx+y8Uovap2zhkly/eE UmxFIjbs8pTIWD4SZfLEeVLk9nUWLBkdTuxcbeWOLSt9EcF9XCMklLfzgKBLHFy35KyB 5Ujqu1CGqk2iLlvXkbipvCMDPoNriUUnf0yv2bXbPQHgVDrcSSLGQSIqOZqqh3NbffSO 38LV4DHZ440UqiMzx/ZCmu7qO16catIKUBL8Rto/TeIIjTFfGDfJYE+KkWUJ0zSajmV2 UqeybaY9PT//TS//2tu2rn6yQFq1PAtVtpcQRTZ735W681dpLI24BNbvQGL0ZS0gDEgv Fe6g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1678459099; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=1ZlLtCFCU5tbP36r0gwBBDs0qxlmFt5WfMKO/PFuwD8=; b=cuSOc+yWSviFRc2QyxjgIOBoPa1MT5j1Ae+iCE+bxCJMuN9mQtYsd5GFBBWYpVfTZ3 b4tFsRMHhlq77Oy63EaYOdVS0nWUQ+7RNA58i7RfFgZr/zt59vF+wG86UbsIwbScjz2U g/P+wU+QC+ZiSVxValHtuvKr9Vqsna93Cw5BGYliDml7RfEGcCIaMYWvOnSxs1KUatBv 9Adn8vhqN+0xq8nUJsDv9yQZ9hwRKaQlHE5c+QvxmrWr5m94EdLLnpdHCwtSpfe5kkQ/ Q4QpRPDZyYvWDr7HWCE7XuDG1qkHqXgrXAH/v1EHyqZRG6KJrJQ3yIgMSoxqYkKNdpVo dO5w== X-Gm-Message-State: AO0yUKWlLbDTXB2qHqlidxNVUaJITtOjcBjUZ5Fxy+S7ka8JUZpo/L7S uHrc95+Z7OPTYyhesMz8plm+gA== X-Google-Smtp-Source: AK7set8d1XpcqCGJq80QioSH0MAz0Ai+X5wOM0fmXZXYtdMJHnY8MJqtu8fw+jEULBxTRvJVD7nEJw== X-Received: by 2002:a17:902:d2d0:b0:19e:65db:7ac3 with SMTP id n16-20020a170902d2d000b0019e65db7ac3mr32826650plc.68.1678459099279; Fri, 10 Mar 2023 06:38:19 -0800 (PST) Received: from jeff-laptop.lan (c-73-231-146-4.hsd1.ca.comcast.net. [73.231.146.4]) by smtp.gmail.com with ESMTPSA id kr13-20020a170903080d00b001991942dde7sm108465plb.125.2023.03.10.06.38.18 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 10 Mar 2023 06:38:18 -0800 (PST) Message-ID: Subject: Re: pgsql: Use ICU by default at initdb time. From: Jeff Davis To: Peter Eisentraut , pgsql-hackers Date: Fri, 10 Mar 2023 06:38:17 -0800 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2023-03-10 at 10:59 +0100, Peter Eisentraut wrote: > I think originally the locale forced the encoding.=C2=A0 With ICU, we hav= e > a=20 > choice.=C2=A0 We could either stick to the encoding suggested by the OS, > or=20 > 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? > Arguably, if we are going to nudge toward ICU, maybe we should nudge=20 > toward UTF-8 as well. The OSes are already doing a pretty good job of that. Regardless, we need to remove the dependence on LC_CTYPE and LC_COLLATE when the provider is ICU first (we're close to that point but not quite there). Regards, Jeff Davis