On Wed, Jun 1, 2022 at 6:15 PM 荒井元成 <n2029@ndensan.co.jp> wrote:
> D209007=# select char_length(U&'\+0066FE' || U&'\+0E0103') ;
> char_length
> -------------
> 2
> (1 行)
>
> I expect length 1.
No opinion here, but I did happen to see Noriyoshi Shinoda's slides
about this topic a little while ago, comparing different databases:
https://www.slideshare.net/noriyoshishinoda/postgresql-unconference-29-unicode-ivs
It's the same with Latin combining characters... we count the
individual codepoints of combining sequences:
postgres=# select 'e' || U&'\0301', length('e' || U&'\0301');
?column? | length
----------+--------
é | 2
(1 row)