On Tue, 2002-05-14 at 09:52, Tatsuo Ishii wrote: > > Are you sure that say, de_DE.utf8 locale produce meaningful results > for any other languages?
there are often subtle differences, but upper() and lower() are much more likely to produce right results than collation order or date/money formats. in fact seem to be only 10 distinct LC_CTYPE files for ~110 locales with most european-originated languages having the same and only tr_TR, zh_??, fr_??,da_DK, de_??, ro_RO, sr_YU, ja_JP and ko_KR having their own. > If so, why are there so many *.utf8 locales? As I understand it, a locale should cover all locale-specific issues > > 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. Are these ASCII and European characters uppercased in some Japanese-specific way ? -------------- Hannu ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org