Re: Question for Postgres 8.3

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                                   ]
>
>