Re: [HACKERS] Bug #659: lower()/upper() bug on

> > My Linux box does not have *.utf8 locales at all. Probably not so many
> > platforms have them up to now, I guess.
>
> What linux do you use ?

Kind of variant of RH6.2.

> At least newer Redhat Linuxen have them and I suspect that all newer
> glibc's are capable of using them.

I guess many RH6.2 or RH6.2 based are still surviving...

> > If you have set the local to, say de_DE, then:
> >
> > select lower(japanese) from t1;
> >
> > would be executed in de_DE.utf8 locale, and I doubt it produces any
> > meaningfull results for Japanese.
>
> IIRC it may, as I think that it will include full UTF8 upper/lower
> tables, at least on Linux.
>
> For example en_US will produce right upper/lower results for Estonian,
> though collation is off and some chars are missing if using iso-8859-1.

Are you sure that say, de_DE.utf8 locale produce meaningful results
for any other languages? If so, why are there so many *.utf8 locales?

> btw, does Japanese language have distinct upper and lower case letters ?

There are "full width alphabets" in Japanese. Thoes include not only
ASCII letters but also some European characters.
--
Tatsuo Ishii