upper bug?

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 - 19:57:57 CDT