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 can be Case Insensitive ?

Re: Oracle can be Case Insensitive ?

From: John Russell <netnews7_at_johnrussell.mailshell.com>
Date: Thu, 04 Sep 2003 22:03:29 GMT
Message-ID: <0bdflvsqmic0n65gubco5juoea5n337tkq@4ax.com>


On 4 Sep 2003 12:07:28 -0500, Galen Boyer <galenboyer_at_hotpop.com> wrote:
>Go to asktom. Type in dbms_output and then DBMS_OUTPUT. You get
>the same number of hits. Then, when you look at the two answers,
>you see that the application code turned it to lower. Okay,
>yeah, I see, he did this little workaround to give the _illusion_
>of a case insensitive world to the users of his site. But, when
>one searches his site, they are in a case insensitive mindset.
>When I'm on a search site, that is my world for that moment, and
>that world is case insensitive. Just one example of the fact
>that we don't live in a case-insensitive world. We live in a
>world that has different flavors of case sensitivity for the
>different situations. But, Oracle only supports the case
>sensitive version of any of these. The application programmers
>have to program for the rest of those cases, exactly as people
>suggest, upper/lower()...

Also if you build an Oracle Text index on a column, the search operator (CONTAINS) is case-insensitive by default.

John

--
Photo gallery: http://www.pbase.com/john_russell/
Received on Thu Sep 04 2003 - 17:03:29 CDT

Original text of this message

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