| From: | "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> |
|---|---|
| To: | 'Peter Eisentraut' <peter(dot)eisentraut(at)2ndquadrant(dot)com>, 'Peter Geoghegan' <pg(at)bowt(dot)ie> |
| Cc: | "maumau307(at)gmail(dot)com" <maumau307(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: How can I find a specific collation in pg_collation when using ICU? |
| Date: | 2017-08-10 01:19:00 |
| Message-ID: | 0A3221C70F24FB45833433255569204D1F780F1A@G01JPEXMBYT05 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Peter Eisentraut
> There are no case-insensitive collations in PostgreSQL (yet).
That's sad news, as I expected ICU to bring its various collation features to PostgreSQL. I hope it will be easy to add them.
From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Peter Geoghegan
> This is not an answer to the question you asked, but it may interest you
> to know that ICU uses JIS X 4061 for Japanese, unlike Glibc. This will give
> more useful results when sorting Japanese.
>
> The best explanation of the difference that I can understand is here, under
> "Why do CJK strings sort incorrectly in Unicode?":
>
> https://dev.mysql.com/doc/refman/5.5/en/faqs-cjk.html
Thanks a lot. MysQL seems to have many collations, doesn't it?
Regards
Takayuki Tsunakawa
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2017-08-10 01:41:05 | Re: Log LDAP "diagnostic messages"? |
| Previous Message | Ashutosh Bapat | 2017-08-10 01:16:36 | Re: Log LDAP "diagnostic messages"? |