On 02/05/2008 03:38 PM, Hiroshi Saito wrote: > Hi. > > This reply is very glad for me!:-) > However, There is still a locale problem. If I use an EUC database on an UTF8 system? Well I will try out and see if it breaks everything. > 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 ] >> >> > -- [ 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 ]
Attachment:
signature.asc
Description: OpenPGP digital signature
