Re: Problem with Case Sensitivity in Oracle?

Bob Chow (bchow_at_rogers.com) wrote:
: 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.

If you are already ensuring the data is written to the database in upercase then simply remove UPPER from your select statement.

--
Steve Corbett.                    vvv
                                 [. .]   "just one person's opinion"
p0070623_at_brookes.ac.uk -------o00-(_)-00o---------