Re: how to configure my database or server to be case-insensitive

I would use a trigger on the tables to convert every entry to UPPER. But you would have to add that on all columns that have char or varchar2 on every new table. The other was is to change your select statement to be

select * from user_table where upper(user_name) like 'JOHN';

--Bob.

Rick Lin wrote in message <70qiqe$gd3$1_at_news1-alterdial.uu.net>...
>Hi,
>
>Is there anyway to configure my database or server to be case-insensitive?
>In other words, I would like my database or server to ignore case while
>doing
>text literal comparsion in all SQL statements. For example, the following
>criteria in where clause will return the same result:
> SELECT * FROM user_table WHERE use_name= 'john'
> SELECT * FROM user_table WHERE use_name= 'John'
> SELECT * FROM user_table WHERE use_name= 'JOHN'
> SELECT * FROM user_table WHERE use_name= 'jOhn'
>
>Thanks,
>
>Rick Lin
>Diffusion, Inc.
>rlin_at_diffusion.com
>
>
>
>
Received on Sun Oct 25 1998 - 00:00:00 CDT