Hi.
This reply is very glad for me!:-)
However, There is still a locale problem.
Anyway, thanks!!!!
Regards,
Hiroshi Saito
----- Original Message -----
From: "Clemens Schwaighofer" <cs@xxxxxxxxxxxxx>
I'm surprised your clients haven't been screaming about bogus sorting
and upper/lowercasing behavior.
Umm, This is a mere information. (Since you dislike, this may be a noise.?)
As for upper/lower.
It does not change, even if uses which locale in us Japanese. (there is
nothing with the alphabet) Then, In spite of using a small letter and a
capital letter properly clearly.
As for sorting.
It has a difference, if sorting of a dictionary is desired. However,
each is the not
Japanese order of the JIS X 4061:1996(Collation of Japanese character
string), probably. but, I think that LOCAL=C is clear as a sorting of a
dictionary. It seems that selection is good by the situation well.
See, Although you may be unable to see (However, this is Japanes shift-jis)
http://winpg.jp/~saito/pg_bug/Japanese_LowerUpper_sort.txt
もしかしたらLinux LOCALEはUTF-8.en_USとPostgresのLOCALEはCその日本語の
ソートは正しくない？僕はいつでもLOCAL=Cある、と今テストしました。ソート
は正しいです。
ありがとうございます。
--
[ Clemens Schwaighofer -----=====:::::~ ]
[ IT Engineer/Manager, TEQUILA\ Japan IT Group ]
[ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN ]
[ Tel: +81-(0)3-3545-7703 Fax: +81-(0)3-3545-7343 ]
[ http://www.tequila.co.jp ]
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
