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

From: "Enke, Michael" <michael(dot)enke(at)Wincor-Nixdorf(dot)com>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: hannu(at)tm(dot)ee, pgsql-bugs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Bug #659: lower()/upper() bug on
Date: 2002-05-17 09:55:42
Message-ID: 3CE4D39E.6C63F322@wincor-nixdorf.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

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

Could you give me the UTF-8 bytecode for one japanese upper case char and
for the same char the lower case?
I will check in de_DE locale if this translations works.

Michael

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andriy I Pilipenko 2002-05-19 10:30:17 match_special_index_operator don't work in 7.2.1
Previous Message Tom Lane 2002-05-17 02:00:15 Re: Wrong version?

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 2002-05-17 11:58:41 Future plans
Previous Message youenn.ballouard2 2002-05-17 08:02:18 Trouble with pg_encoding_to_char