I'm trying to find out the same at the moment. According to some postings in
deja, there is no such flag or option or anything. Some people suggest to
have a second column with an upper case copy of the original text data. Some
suggest to use the upper function in the comparison like this: select name
from your_table where upper(name) = 'CARLOS'. But that has the drawback that
the index isn't used which is impossible if you hav more than a few records
in the table. The solution seems to be to use a function index. That's a new
feature of Oracle 8i. I haven't tried that though.
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 - 05:58:55 CST
