Re: Help!!: Case sensitive in data

Hi,

Make sure the front end changes to uppercase before the insert, not always acceptable, but will take the drain off the server using functions like UPPER which (correct me if I am wrong) wont use indexes and will more often than not generate a full table scan - ouch.

Regards

Adrian Shepherd

C. Patrice wrote in message <3487DBB5.E9C58C9_at_hotmail.com>...
> Hi ALL!
>
>I have problem with CASE SENSITIVE in data. For example,
>when i give my request:
> SELECT * FROM table_name WHERE column1 LIKE 'value1'
>
>This request gives results different from the ones given by the request:
>
>SELECT * FROM table_name WHERE column1 LIKE 'Value1'
>
>The solution to solve CASE SENSITIVE is to use UPPER:
> SELECT * FROM table_name WHERE UPPER(column1) LIKE UPPER('value1')
>
>But i would like to know how to configure ORACLE so that we don't need
>to user
>the operator UPPER in requests.
>
>Thank for help.
>
Received on Mon Dec 08 1997 - 00:00:00 CET