Re: Question for Postgres 8.3 - Mailing list pgsql-general

From Hiroshi Saito
Subject Re: Question for Postgres 8.3
Date
Msg-id 0a2601c867be$a1e05560$0301a8c0@HP22720319231
Whole thread Raw
In response to Question for Postgres 8.3  (Clemens Schwaighofer <cs@tequila.co.jp>)
List pgsql-general
> 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

Regards,
Hiroshi Saito





pgsql-general by date:

Previous
From: Ken Johanson
Date:
Subject: Re: failed to build any 8-way joins: SQLSTATE: XX000 on PostgreSQL 8.2.6
Next
From: Pepe Barbe
Date:
Subject: Re: PostgreSQL 8.3.0 RPMs are available for download