; t...@sss.pgh.pa.us;
pgsql-hackers@lists.postgresql.org
Subject: Re: collate not support Unicode Variation Selector
At Wed, 3 Aug 2022 20:12:53 +0900, 荒井元成 wrote in
> Thank you for your reply.
>
> About 60,000 characters are registered in the IPAmj Mincho font designated
by the
Thank you for your reply.
About 60,000 characters are registered in the IPAmj Mincho font designated by
the national specifications.
It should be able to handle all characters.
regards.
-Original Message-
From: Kyotaro Horiguchi
Sent: Wednesday, August 3, 2022 3:26 PM
To: thomas.mu.
Hi, I hope supported Unicode Variation Selector on collate.
I will resend it because there was a typo.
D209007=# create table ivstest ( moji text collate "ja-x-icu" CONSTRAINT
firstkey PRIMARY KEY );
D209007=# insert into ivstest (moji) values ( U&'\+003436' || U&'\+0E0101' ||
U&'\+00304D');
Hi, I hope supported Unicode Variation Selector on collate.
D209007=# create table ivstesticu (
D209007(# moji text
D209007(# );
D209007=# create table ivstest (
D209007(# moji text collate "ja-x-icu" CONSTRAINT firstkey PRIMARY KEY
D209007(# );
D209007=# insert into ivstest (moji) values ( U&'
|starts_with
Best regards,
-Original Message-
From: Daniel Verite
Sent: Wednesday, June 1, 2022 6:46 PM
To: Thomas Munro
Cc: 荒井元成 ; Peter Eisentraut
; PostgreSQL Hackers
Subject: Re: Unicode Variation Selector and Combining character
Thomas Munro wrote:
> Looking aroun
Hi,
I tried it on PostgreSQL 13. If you use the Unicode Variation Selector and
Combining Character
, the base character and the Variation selector will be 2 in length. Since it
will be one character on the display, we expect it to be one in length. Please
provide a function corresponding to
