Per my test in CentOS, the sort order of UTF-8 characters were completely different between locale C, ja_JP.UTF-8 and en_US.UTF-8.
Conversation
Replying to
I'm told JIS X 4061 offers the most useful sort order for Japanese, but unsupported by glibc: userguide.icu-project.org/collation/conc
Should we still rely on only the glibc implementation? Could we have another solution?
1
Personally, I believe that ICU support would be very useful, for several reasons.
1
Show replies
Replying to
thanks for the info! that sounds nice. but I'm sure many Japanese DBA would prefer locale-C because of performance.
1
Replying to
icu gets you back abbreviated keys, so maybe it won't matter. Standard I mentioned is particularly slow, though.
1
Show replies