Re: Unicode Variation Selector and Combining character - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: Unicode Variation Selector and Combining character
Date
Msg-id CA+hUKGJnHawQbeZMP7iPfA_eQ_EE0AbAiJ15XC=aEEe1ywh9yg@mail.gmail.com
Whole thread Raw
In response to RE: Unicode Variation Selector and Combining character  (荒井元成 <n2029@ndensan.co.jp>)
Responses Re: Unicode Variation Selector and Combining character
List pgsql-hackers
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)



pgsql-hackers by date:

Previous
From: 荒井元成
Date:
Subject: RE: Unicode Variation Selector and Combining character
Next
From: Thomas Munro
Date:
Subject: Re: Unicode Variation Selector and Combining character