Re: Question for Postgres 8.3

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(at)tequila(dot)co(dot)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 ]
>>
>>
>

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