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

Do I wish there was an anwer to this one. The only thing we do is de-normalized and have two columns. One called user_name, and the other called user_name_uppercase. Then, you can use a trigger to maintain the upper one. On Fri, 23 Oct 1998 11:48:28 -0700, "Rick Lin" <rlin_at_diffusion.com> wrote:

>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 Wed Oct 28 1998 - 00:00:00 CST