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 1rkpTz-00FjyJ-Tb for pgsql-hackers@arkaria.postgresql.org; Thu, 14 Mar 2024 18:07:12 +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 1rkpTy-001uZJ-Gf for pgsql-hackers@arkaria.postgresql.org; Thu, 14 Mar 2024 18:07:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rkpTy-001uZB-2B for pgsql-hackers@lists.postgresql.org; Thu, 14 Mar 2024 18:07:10 +0000 Received: from mail-pf1-x435.google.com ([2607:f8b0:4864:20::435]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rkpTq-004VQ5-Dg for pgsql-hackers@postgresql.org; Thu, 14 Mar 2024 18:07:09 +0000 Received: by mail-pf1-x435.google.com with SMTP id d2e1a72fcca58-6e6082eab17so1204939b3a.1 for ; Thu, 14 Mar 2024 11:07:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1710439622; x=1711044422; 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=AnaFktYWZuo9qKBtCqu6GQiqyQFk6Z8tJT5ERM+KdrM=; b=I72X2wxmJVdML0/CQLXvQCDPh5g/t9zV56MhdzsGBClHaSYDlhXjvyCrY86Shz1+nL tYBYd0Ipb795MW61y0+LSbvi5WbJJzSnD/ejK6KpRjIdux7tIa4wlzTJEZjwVNCWgFzr th8IJ9uVAGrHPsh7JKjipo8eLgSmH/TKk0iXGhs30H1nO3DU6LUbKAu9TUZkA5y0CA3V lsnXPtvrtRVEFb+TCR4DjC9zPpvxRmv8yfEsFrU7r0ZQV68ItjJxLw3lG/escjwif79b EibakIpwvdpxcFZP8ZbbX/QqVd80SXyKUWhun+EpJ5gS1sjIIM3rxep0q8A9zNt23X+r pvWg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1710439622; x=1711044422; 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=AnaFktYWZuo9qKBtCqu6GQiqyQFk6Z8tJT5ERM+KdrM=; b=qGyOET2hRGmUm4ahaRyjKrrlMVTRC0VeSn2zqPAzaS0I0UTrUikbx7/eGAgTNgS658 st80bd3mHuAVc8PSjkG/Y5+dmynh6Ed7wl1H3hlLukN7cMxtWsJJUWpFUGKfK63lryrl FXjP9VaJrnPT74lAUmS160rhHnaX2GlKKTMU6uBxFhoswwyGuKXUs7xJrcey0MThsS8M QBvdAxhLnwM/5Bg1QNWXJ8yQZo2ejy+jAZTaHZDfZk+Nz+JRuV9K5BRJq7wrrBuXb7IU tL81QBRwR/XjTmrUP+hle6UD/2EWn7gYxzoSXdpKZVn+3acDBYJQoiALut2OATTafYDx t5Dg== X-Gm-Message-State: AOJu0YxtvvhHnU3ck5go6rNOEIZG/rJdbSkF1GP3FPav+5GS2p/e4k4c e+/nM0UmM5TRlVbabtT8yCD03tpd3bvOATVzesjrq0UU82knvwrvbd39c84I1A== X-Google-Smtp-Source: AGHT+IHyXrL5vQ0kwl2ZwN6bCi5XHgOB+JgeLkoaYbGIr1rv7BuaebG4zOb7obfIdnT3qsMi9jkn6Q== X-Received: by 2002:a05:6a21:3284:b0:1a3:24e7:3280 with SMTP id yt4-20020a056a21328400b001a324e73280mr3136299pzb.61.1710439622518; Thu, 14 Mar 2024 11:07:02 -0700 (PDT) Received: from jeff-laptop.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id g1-20020aa79dc1000000b006e6c733bde9sm1788340pfq.155.2024.03.14.11.07.01 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 14 Mar 2024 11:07:02 -0700 (PDT) Message-ID: Subject: Re: Pre-proposal: unicode normalized text From: Jeff Davis To: Robert Haas , Peter Eisentraut Cc: pgsql-hackers@postgresql.org Date: Thu, 14 Mar 2024 11:07:00 -0700 In-Reply-To: References: <33a31c45-2e80-1270-771a-b75f3920a5ec@eisentraut.org> 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 Thu, 2024-02-29 at 17:02 -0800, Jeff Davis wrote: > Attached is an implementation of a per-database option STRICT_UNICODE > which enforces the use of assigned code points only. The CF app doesn't seem to point at the latest patch: https://www.postgresql.org/message-id/a0e85aca6e03042881924c4b31a840a915a9d= 349.camel@j-davis.com which is perhaps why nobody has looked at it yet. But in any case, I'm OK if this gets bumped to 18. I still think it's a good feature, but some of the value will come later in v18 anyway, when I plan to propose support for case folding. Case folding is a version of lowercasing with compatibility guarantees when you only use assigned code points. Regards, Jeff Davis