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,