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 ) id 1qoAs6-000OVb-QF for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Oct 2023 23:01:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qoAs4-006I1w-QK for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Oct 2023 23:01:37 +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 ) id 1qoAs4-006I1b-Cu for pgsql-hackers@lists.postgresql.org; Wed, 04 Oct 2023 23:01:37 +0000 Received: from mail-oi1-x22d.google.com ([2607:f8b0:4864:20::22d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qoAry-0004PJ-HR for pgsql-hackers@postgresql.org; Wed, 04 Oct 2023 23:01:36 +0000 Received: by mail-oi1-x22d.google.com with SMTP id 5614622812f47-3af609b9264so242557b6e.2 for ; Wed, 04 Oct 2023 16:01:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1696460489; x=1697065289; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=7M+L+KoFa39xjSnQbW30c+GH2qPoLiXsePkrsoHooQY=; b=RgTnMdKL0Ocs7QdMT7hnPisEajJ1Va3SG2JWvzLpxbpHn3VlRjtwrY22JdTuYQmfqb ZPBmIf7cTjUqa17/v2yjO010MXqNk6TZWLUb18jurCrbo1gJgfv4mmIql6fjdpAiYDEP Eo4OFUaFxbtaNgeh5cgLHVuR6Gv90zXEJL5VOqpFtqENCOlNrf9P68RQXfKyMcLlKkf/ 3gAPGBFf+WiinsI76N/6z28F2mFKJ0GK4YTifXDHwgiwnauPnagg81rog8XAmNcA1ilE Kbi3VuR3mMgkFNxdwsFSzwzsvNEKMWbiJH046T3Sm/zLfIVkvuVjq0jeKqkl8Hwu7I4+ C/YA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1696460489; x=1697065289; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=7M+L+KoFa39xjSnQbW30c+GH2qPoLiXsePkrsoHooQY=; b=wx63cL4OnTrY6CmooN5aSSp5Edsx32xysRZS7j502fhdMJA5RQ2EPZBvjN9cxNtW0E sbS0PkL+hxh7yJNglXivtMYkC888/ddH+6vT+MeovSS5j9sIRiwqC7CC2xEPJmSD0HSK nik/nCLs3GJ/NtMW35gWIaY+Jx7uifxxpxq/9OucBG23L4h0ZdKdmpPidycSLXX9cGPb mRZMdOTW6MoiYt2hf1y4MjkqNnAXLDN03vm/INBbgRTVJASPNSODSGmRzBUB/OuY6lPG 2GudSrDMJNAUW3NrDyzP/UHg6FEgGTcB7imA8/Ow5bidZLrfr5fetMY1YdvGTAT4Mlt/ +orQ== X-Gm-Message-State: AOJu0YwXhVDQBpBuyX2vk1K4uic2CQR9Ug7y5HGjWp42MYbm5bMyGSpm 5YmFd7wUv6dLf70r9wJ1WeSzMQ== X-Google-Smtp-Source: AGHT+IGOcUCWNmHzqkRJu8RfPyKneFa8xZNwnCxpBmZFDquAP+DTTjeZXGF52p4iQTkGwbG4LwWZNw== X-Received: by 2002:a05:6358:7e49:b0:143:55e2:ce82 with SMTP id p9-20020a0563587e4900b0014355e2ce82mr3759863rwm.3.1696460488617; Wed, 04 Oct 2023 16:01:28 -0700 (PDT) Received: from jeff-laptop.lan (c-98-45-81-55.hsd1.ca.comcast.net. [98.45.81.55]) by smtp.gmail.com with ESMTPSA id mp3-20020a17090b190300b00267d9f4d340sm2139417pjb.44.2023.10.04.16.01.27 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 04 Oct 2023 16:01:28 -0700 (PDT) Message-ID: <573029acb7dd0956fb5334c3a3b71ffee16b4c0d.camel@j-davis.com> Subject: Re: Pre-proposal: unicode normalized text From: Jeff Davis To: Nico Williams Cc: Chapman Flack , Robert Haas , pgsql-hackers@postgresql.org Date: Wed, 04 Oct 2023 16:01:26 -0700 In-Reply-To: References: <43864caecd65d02081d623d05ccc1683@anastigmatix.net> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2023-10-04 at 16:15 -0500, Nico Williams wrote: > Better that than TEXT blobs w/ the encoding given by the `CREATE > DATABASE` or `initdb` default! From an engineering perspective, yes, per-column encodings would be more flexible. But I still don't understand who exactly would use that, and why. It would take an awful lot of effort to implement and make the code more complex, so we'd really need to see some serious demand for that. Regards, Jeff Davis