Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Case sensitive ORACLE
1 - select name from emp where upper(name) =upper('CARLOS')
I think this way the index will be ignored (if the column "name" is indexed).
2 - Enforce that all inserts, updates ans selects will be made with uppercase OR lowercase.
"Carlserra" <carlserra_at_hotmail.com> wrote in message
news:81tmii$3ou$1_at_lola.ctv.es...
> Hi:
>
> I have a problem. Oracle is case sensitive. Is there any flag or any
special
> configuration to convert Oracle to not case sensitive.
>
> Example:
>
> When a use select...
>
> select name from emp where name ='CARLOS'
> select name from emp where name ='carlos'
>
> 'CARLOS' is diferent than 'carlos' but i donīt want.
> I want that 'CARLOS' = 'carlos'
>
> It's impossible?
>
> Thank you.
> CARLSERRA
>
>
Received on Mon Nov 29 1999 - 10:52:27 CST