Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> how to configure my database or server to be case-insensitive

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

From: Rick Lin <rlin_at_diffusion.com>
Date: 1998/10/23
Message-ID: <70qiqe$gd3$1@news1-alterdial.uu.net>#1/1

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 Fri Oct 23 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US