Problem with Case Sensitivity in Oracle?
Date: Wed, 2 Mar 1994 14:03:15
Message-ID: <bchow.25.000E0E57_at_rogers.com>
Hello all,
I am running into a problem with case sensitivity of Oracle. As you know, Oracle is sensitive to upper or lower case character strings. To accommodate this, I upshift the data inputted from the user in my application as well as using the Oracle UPPER function in a Select statement. This way , I ensure the I am comparing 2 strings with the same Case. The trouble with this is that, when one manipulates a column using a function such as UPPER, the Optimizer will suppress use of the index associated with that column, causing a performance problem. (I use PowerBuilder as the application development environment).
Does anyone know of any trick or function that tells Oracle in my DML statement to ignore the case or any other workaround to this problem. Thanks in advance.
Example:
Select contactnumber,contactname, companyname
from contactdirectory where
contactnumber > 100 and UPPER (contactname) like UPPER ('ted rogers') and
BC Received on Wed Mar 02 1994 - 14:03:15 CET