> > 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
