Re: Case Insensitive: Oracle 8?

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 22 Aug 1998 22:25:29 GMT
Message-ID: <35e64243.5157087@netnews.worldnet.att.net>

On Sat, 22 Aug 1998 16:32:52 -0400, Patrick Durusau <pdurusau_at_unix.cc.emory.edu> wrote:

>Does Oracle 8 permit case insensitive searching without use of the UPPER()
>function?

No, it does not. There is a way to deal with this issue and avoid having to use the UPPER function with all the performance problems that raises. If you are searching on last name for example, add a "shadow" column to your table that contains the last name in all uppercase (or lowercase). Write a trigger to maintain this column whenever the real name column is changed. Your queries can then reference this shadow column in the WHERE clause, but they can return the regular, upper/lower case value to the application.

regards,

Jonathan Received on Sat Aug 22 1998 - 17:25:29 CDT