Re: Question for Postgres 8.3
От | Hiroshi Saito |
---|---|
Тема | Re: Question for Postgres 8.3 |
Дата | |
Msg-id | 0a6001c867c1$c24acc10$0301a8c0@HP22720319231 обсуждение исходный текст |
Ответ на | Question for Postgres 8.3 (Clemens Schwaighofer <cs@tequila.co.jp>) |
Ответы |
Re: Question for Postgres 8.3
|
Список | pgsql-general |
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@tequila.co.jp> >>> 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 ] > >
В списке pgsql-general по дате отправления: