Re: Case sensitive ORACLE

Meanwhile I have found something in the Oracle documentation in the NLS section:

Case-Insensitive Sorting

You can create a function-based index which allows case-insensitive searches. For example:

SVRMGR> CREATE INDEX case_insensitive_ind ON my_table(NLS_UPPER(empname)); SVRMGR> SELECT * FROM my_table WHERE NLS_UPPER(empname) = 'KARL';

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 - 06:18:37 CST