Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> oracle upper error

oracle upper error

From: <mikeys_at_web.de>
Date: Tue, 19 Dec 2000 10:47:06 GMT
Message-ID: <91neb9$hgm$1@nnrp1.deja.com> 






Hi there.



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 ?


Any Solutions ?



Please help me !


Mike.





Sent via Deja.com


http://www.deja.com/
Received on Tue Dec 19 2000 - 04:47:06 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US