Re: upper bug?

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Wed, 15 May 2002 08:57:49 +0600
Message-ID: <absir7$jssat$1@ID-127142.news.dfncis.de>

Hi,

what character set are you using? Isn't it 7-bit charset? I've just checked it with my 8-bit charset - works quite fine. (Oracle 8.1.7 on Solaris)

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com


"Richard Kuhler" <noone_at_nowhere.com> wrote in message
news:poiE8.1404$DF2.385508_at_twister.socal.rr.com...


> Why does the Oracle UPPER function convert ascii 128-255 into ascii

> 0-127?

>

> > select ascii(upper(chr(128))) from dual;

>

> ASCII(UPPER(CHR(128)))

> ----------------------

>                      0

>

> > select ascii(upper(chr(180))) from dual;

>

> ASCII(UPPER(CHR(180)))

> ----------------------

>                     52

>

> > select ascii(upper(chr(255))) from dual;

>

> ASCII(UPPER(CHR(255)))

> ----------------------

>                    127

>

>

> Is there a way to fix this?  Note: NLS_UPPER does the same thing.

>

>

> Thanks,

> Richard

>

Received on Tue May 14 2002 - 21:57:49 CDT