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

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
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:40:38
Message-ID: 1021383638.3318.16.camel@taru.tm.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-05-14 15:43:34 Re: points and boxes - core dump
Previous Message Tatsuo Ishii 2002-05-14 13:18:52 Re: [HACKERS] Bug #659: lower()/upper() bug on

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-05-14 13:52:47 Re: Discontent with development process (was:Re: pgaccess - the discussion is over)
Previous Message Tom Lane 2002-05-14 13:39:17 Re: strange explain