collate not support Unicode Variation Selector - Mailing list pgsql-hackers

From 荒井元成
Subject collate not support Unicode Variation Selector
Date
Msg-id 001201d8a6cb$35689d50$a039d7f0$@ndensan.co.jp
Whole thread Raw
Responses RE: collate not support Unicode Variation Selector
List pgsql-hackers
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&'\+003436' || U&'\+0E0101' || U&'\+00304D');
D209007=# insert into ivstest (moji) values ( U&'\+003436' || U&'\+00304D');
D209007=# select moji from ivstest where moji like '%' || U&'\+00304B' || '%';
-------------
㐶󠄁き
㐶き
(2 行)

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


Best regards,





pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: Adding Support for Copy callback functionality on COPY TO api
Next
From: 荒井元成
Date:
Subject: RE: collate not support Unicode Variation Selector