| From: | "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp> |
|---|---|
| To: | "Clemens Schwaighofer" <cs(at)tequila(dot)co(dot)jp>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Question for Postgres 8.3 |
| Date: | 2008-02-05 06:16:23 |
| Message-ID: | 0a2601c867be$a1e05560$0301a8c0@HP22720319231 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pepe Barbe | 2008-02-05 06:20:10 | Re: PostgreSQL 8.3.0 RPMs are available for download |
| Previous Message | Ken Johanson | 2008-02-05 06:06:48 | Re: failed to build any 8-way joins: SQLSTATE: XX000 on PostgreSQL 8.2.6 |