Re: oracle upper error

mikeys_at_web.de wrote:
: I've got the following sql statement on an oracle db:
: select USR_SURNAME from USR_USERINFORMATIONS where upper(USR_SURNAME)
: like upper('%v%');
: When I start this statement I got all surnames which contains "v".
: That's right. But I also get the surnames which contains "ö" an no "v".
: The same error is given when I search after "ä", "ö" or "ü".
 

: Is this an oracle bug ?

The ASCII representation of "ö" is 0366 (octal); truncate this to 7 bits, and you get 0166, which is the ASCII representation of "v".

(1)

export NLS_LANG=AMERICAN_AMERICA.US7ASCII sqlplus scott/tiger
SQL> SELECT UPPER('Knödel') FROM dual;

KNVDEL (2)

export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 sqlplus scott/tiger
SQL> SELECT UPPER('Knödel') FROM dual;

KNÖDEL Use the right 8-bit character set, and everything works fine.

   Peter Marksteiner

-- 
Vienna University Computer Center