Re: Oracle 7.0: Case insensitive string comparisons?
From: Chris Jack <chrisj_at_pro-data.demon.co.uk>
Date: Sat, 8 Jan 1994 13:43:03 +0000
Message-ID: <758036583snz_at_pro-data.demon.co.uk>
Date: Sat, 8 Jan 1994 13:43:03 +0000
Message-ID: <758036583snz_at_pro-data.demon.co.uk>
In article <7JAN199410585816_at_cccs.umn.edu> mcj_at_cccs.umn.edu writes:
>
>This is a fairly standard problems but I do not know of an Oracle solution.
>
>Potential solutions we have considered:
> Store names/addresses in normal format, e.g Mark Jones
> Problem indexed search will not find match if search criteria
> entered as MARK JONES, and if we force the database column to
> uppercase in the comparison then index will not be used.
>
Can't you make the index on _at_upper() of the column?
-- Chris JackReceived on Sat Jan 08 1994 - 14:43:03 CET