Re: What is the difference between UPPER and NLS_UPPER when applied to "normal" characters

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/10/10
Message-ID: <343df826.11787360@www.sigov.si>#1/1

On Thu, 09 Oct 1997 10:29:48 -0400, "Michael G. Schneider" <mgs_software_at_compuserve.com> wrote:

>What is the difference between UPPER and NLS_UPPER when applied to "normal"
>characters. Have a look at the following lines.
>
> CREATE TABLE tbl (fld CHAR(30));
> INSERT INTO tbl VALUES ('abc');
>
> SELECT fld FROM tbl
> WHERE UPPER(fld) = UPPER('abc');
>
> SELECT fld FROM tbl
> WHERE NLS_UPPER(fld,'NLS_SORT=German') =
>NLS_UPPER('abc','NLS_SORT=German');
>
>I thought, both selects would bring back the same resultset. However, the
>second select won't return anything at all.

Strange, I tested your example and it worked as it should.

SQL> select fld from tbl
  2 where nls_upper(fld,'NLS_SORT=German') =   3 nls_upper('abc','NLS_SORT=German');

A

---

abc

SQL>
>Michael G. Schneider
>
>mgs_software_at_compuserve.com

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Oct 10 1997 - 00:00:00 CDT