case insensitivity in database creation and SQL statements

From: Ramin Sepehr Rad <ras_at_aa.alma.net>
Date: Fri, 21 Aug 1998 12:59:43 -0400
Message-ID: <Pine.BSI.3.91.980821125520.28924A-100000_at_aa.alma.net>

We are running Oracle 8 on Solaris 2.5.1 running on sparc.

How do I create a database that is case insensitive? I believe that ANSI SQL requires such capability and Oracle is supposedly ANSI/OSI compliant. (I have never read the standard.)

Also, if I do a SELECT on a field that is indexed, but I use the "upper" function, does that still take advantage of the index? I was told by our dba that this SELECT statement will surf the whole table.

Thanks,
-ramin Received on Fri Aug 21 1998 - 18:59:43 CEST

This message: [ Message body ]
Next message: Paul Chang: "switch sybase to oracle"
Previous message: Martin Brown: "Re: Supporting Multiple DBMS"
Next in thread: Joel Garry: "Re: case insensitivity in database creation and SQL statements"
Reply: Joel Garry: "Re: case insensitivity in database creation and SQL statements"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message