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

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: hannu(at)tm(dot)ee
Cc: michael(dot)enke(at)wincor-nixdorf(dot)com, pgsql-bugs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Bug #659: lower()/upper() bug on
Date: 2002-05-14 13:18:52
Message-ID: 20020514221852G.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

> > 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.

I see. So the remaining problem would be how to detect the existence
of *.utf8 collation at the configure time.

> > 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 ?

Probably not, but I'm not sure since my Linux box does not have *.utf8
locales.
--
Tatsuo Ishii

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hannu Krosing 2002-05-14 13:40:38 Re: [HACKERS] Bug #659: lower()/upper() bug on
Previous Message Ewald Geschwinde 2002-05-14 10:28:17 points and boxes - core dump

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2002-05-14 13:39:02 Re: Interval precision busted?
Previous Message Oliver Elphick 2002-05-14 12:49:00 Re: Current anon cvs does not generate GNUmakefile