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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle case in sensitive

Re: Oracle case in sensitive

From: Kevin McDaniel <kmcdaniel96_at_home.com>
Date: Mon, 11 Dec 2000 12:51:55 GMT
Message-ID: <L54Z5.42355$Y6.9538821@news1.mntp1.il.home.com> 






I agree with the others, you could use a case conversion function.  However,
by default, the values in a table ARE case sensitive.  Therefore, scott does
NOT equal SCOTT.   I just confirmed my theory and it's true.  So unless your
query is changing the case, you should not be getting rows returned if you
are entering the wrong case.  Hope this helps.



Kevin
Received on Mon Dec 11 2000 - 06:51:55 CST












Original text of this message













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