Re: Case sensitive

Gert Rijs wrote:
>
> Antonio Melo wrote:
> >
> > Hi
> >
> > Someone knows if/how is it possible to look at text data in a case insensitive way?
> >
> > Eg:
> >
> > $ insert into t1 (name) values ('Mary Ann');
> > $ insert into t1 (name) values ('MARY SMITH');
> > $ select name from t1 where name like 'Mar%';
> > $ rem this would get both records.
> >
> > options:
> > 1. put all text in CAPITALS => my users don't want it
> > 2. use " where upper(name) like 'MAR%' " => performance problems...
> > ->3. define somewhere/somehow/someoption in oracle server ?????
> > 4. ?
> >
> > Thanks in advance
> > Antonio
> >
> > ps: please also reply directly to my e-mail
> >
>
> 4. Add an extra column to the table (upp_name) that is filled
> automatically by a before-update/before-insert trigger (uppercase
> ofcourse).
> 5. Add `where name like 'M%' or name like 'm%'´ to your where-clauses
> (depending on cardinality of name).
>
> --
> Gert Rijs
> mailto:gem_at_wirehub.net (at home)
> mailto:gert.rijs_at_corp.ah.nl (at work)

That is solution that I use in my site and it works fine ( including performance).

David Ng Received on Sun Nov 17 1996 - 00:00:00 CST