From: | "MauMau" <maumau307(at)gmail(dot)com> |
---|---|
To: | "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | How can I find a specific collation in pg_collation when using ICU? |
Date: | 2017-08-09 12:38:52 |
Message-ID: | F54AD68D943D4482ACB343EE3A46C674@tunaPC |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello,
I tried to find a particular collation name in pg_collation, but I
cannot understand the naming convention after reading the following
article. Specifically, I want to find out whether there is some
collation equivalent to Japanese_CI_AS in SQL Server, which means
Japanese, case-insensitive, and accent sensitive. Could you tell me
how to do this? Is there any room to improve the PG manual?
https://www.postgresql.org/docs/devel/static/collation.html
--------------------------------------------------
23.2.2.2.2. ICU collations
With ICU, it is not sensible to enumerate all possible locale names.
ICU uses a particular naming system for locales, but there are many
more ways to name
a locale than there are actually distinct locales. (In fact, any
string will be accepted as a locale name.) See
http://userguide.icu-project.org/locale
for information on ICU locale naming.
--------------------------------------------------
Regards
MauMau
From | Date | Subject | |
---|---|---|---|
Next Message | Aleksander Alekseev | 2017-08-09 12:47:02 | Re: Cache lookup errors with functions manipulation object addresses |
Previous Message | Robert Haas | 2017-08-09 12:23:48 | Re: Default Partition for Range |