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 Tue Oct 27 1998 - 20:13:28 CST
