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 -> Re: Case Insensivetiness...

Re: Case Insensivetiness...

From: Kenneth Jensen <kj_at_computerhelp.dk>
Date: Tue, 15 May 2001 13:06:54 +0200
Message-ID: <9dr2ap$g5e$1@news.inet.tele.dk>

Thank you very much. That does the trick.

I am used to SQL Server, and there you just make your entire DB case insensitive. The UPPER function works with both SQL Server and Oracle, though, so I'll use that function in the future.

Yours Sincerely
Kenneth Jensen

"Patrick Sinke" <patrick.sinke_at_capgemini.nl> wrote in message news:989926049.462019_at_sleeper.capgemini.nl...
> Make your entire database case-insensitive? Why would that be necessary?
> I recommend to place an UPPER round your column-name (mind the possible
> performance drop) or placing the value in the table in only lower- or
> uppercase.
>
> But without further details I cannot say more that would make sense.
 sorry.
>
> Regards,
>
> Patrick Sinke.
>
> Kenneth Jensen <kj_at_computerhelp.dk> schreef in berichtnieuws
> 9dqv77$8i5$1_at_news.inet.tele.dk...
> > Is it possible to make my Oracle DB case insensitive? I want to use the
 LIKE
> > syntax without having to worry about upper case or lower case.
> >
> > Regards,
> > Kenneth Jensen
> >
> >
>
>
Received on Tue May 15 2001 - 06:06:54 CDT

Original text of this message

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