Re: CASE SENSITIVITY AND INDICES AND COLUMNS

From: Will Kooiman <wkooiman_at_csac.com>
Date: 1997/05/29
Message-ID: <338E4EC7.2A28@csac.com>#1/1

Currently the best way to solve this problem is to do both. Store the name exactly as entered AND in upper case. This way you have the correct case of the file name for later use, and you can index the upper case column for searches.

upper() disables the use of indexes, just like all functions (almost all functions. trunc() on a date column doesn't disable indexes, but I think it's the only exception).

Will.

-- 
======================================================================
Will Kooiman                        Computer Systems Authority
Systems Consultant                  6380 LBJ Freeway, Suite 181
(972) 960-0180 x236                 Dallas, TX 75240
mailto:wkooiman@csac.com            http://www.csac.com

Received on Thu May 29 1997 - 00:00:00 CDT