From: Tom Lane <tgl@sss.pgh.pa.us>
To: Holger Jakobs <holger@jakobs.com>
cc: pgsql-admin@lists.postgresql.org, n2029@ndensan.co.jp
Subject: Re: About Unicode IVS
In-reply-to: <15e893e2-1237-27f4-58ba-5ea59499fa3d@jakobs.com>
References: <00e201d8431c$cb38eb40$61aac1c0$@ndensan.co.jp>
 <CAKFQuwYCTmp5t5_7n+qRoKZArnBvv309CSi4XVdONXxQL6OX0Q@mail.gmail.com>
 <00f601d84326$5367cf00$fa376d00$@ndensan.co.jp>
 <006501d84350$37bae6f0$a730b4d0$@msym.fr>
 <012c01d84353$1f8a8d30$5e9fa790$@ndensan.co.jp>
 <15e893e2-1237-27f4-58ba-5ea59499fa3d@jakobs.com>
Comments: In-reply-to Holger Jakobs <holger@jakobs.com>
	message dated "Tue, 29 Mar 2022 12:02:18 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1107955.1648549556.1@sss.pgh.pa.us>
Date: Tue, 29 Mar 2022 06:25:56 -0400
Message-ID: <1107956.1648549556@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1107956.1648549556%40sss.pgh.pa.us>
Precedence: bulk

Holger Jakobs <holger@jakobs.com> writes:
> It's totally correct that the two characters are still two characters.
> You would have to normalize the string first, so that the combination 
> becomes one character.

Yeah.  In principle the normalize() function ought to do this for
you.  But it doesn't seem to shorten the given example for me;
I'm not sure if that means the example is incorrect, or if it's
a bug in normalize().

u8=# select octet_length(U&'\+008FBA' || U&'\+0E0102');
 octet_length 
--------------
            7
(1 row)

u8=# select octet_length(normalize(U&'\+008FBA' || U&'\+0E0102'));
 octet_length 
--------------
            7
(1 row)

			regards, tom lane