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');
D209007=# insert into ivstest (moji) values ( U&'\+003436' || U&'\+00304D');
D209007=# select moji from ivstest where moji like '%' || U&'\+003436' || '%';
-------------
㐶󠄁き
㐶き
(2 行)

expected
-------------
㐶き
(1 行)


Best regards,






Reply via email to