collate not support Unicode Variation Selector

From: 荒井元成 <n2029(at)ndensan(dot)co(dot)jp>
To: "'PostgreSQL Hackers'" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: 荒井 元成 <n2029(at)ndensan(dot)co(dot)jp>
Subject: collate not support Unicode Variation Selector
Date: 2022-08-02 23:54:31
Message-ID: 001201d8a6cb$35689d50$a039d7f0$@ndensan.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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,

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message 荒井元成 2022-08-03 00:09:35 RE: collate not support Unicode Variation Selector
Previous Message Nathan Bossart 2022-08-02 23:49:19 Re: Adding Support for Copy callback functionality on COPY TO api