From: [email protected] > [mailto:[email protected]] 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: [email protected] > [mailto:[email protected]] 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 -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
