Re: Is Oracle is CASE SENSITIVE

Maybe you can create a second column in your table, that is the uppercas e
representation of the name (a database trigger can fill in this field

automatically). Then you can select all rows where the uppercase column

is the same.

Marc

>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<

Op 2000-11-01, 23:03:00, schreef Liz Reen <lizr_at_geologist.com> over het

thema Re: Is Oracle is CASE SENSITIVE:

> In article <8tbp7o$n84$1_at_soap.pipex.net>, n-litchfield_at_audit-
> commission.gov.uk says...
> >
> > It should be self evident that storing data where an a is different
from
an
> > A is more flexible and therefore more desirable system. the case

insensitive
> > world is a subset of the case sensitive world.
> >
> Coming from the VMS world where case is preserved, but it is case
> insensitive. I do not see why you would want a SMITH to be different
 

> from Smith or SmItH. The "genius" who designed the commerce system we
 

> use decided to let the customers have a free form name field. I would
 

> dearly love to be able to do a case insensitive search. For the commo
 n
> last name of Smith, I can find Smith, smith, SMITH, and SmItH in the
> database. My customer service people have to try all possible
> combinations. If some one wishes for me to send them a package to Mr.
 

> JoE SmItH, that is fine with me. I just would like to do a search and
 

> catch all of the variations.
 

> Liz, who is stuck on 7.3.4 so please do not tell me about function
> indexes.
Received on Wed Nov 08 2000 - 00:44:43 CST