Re: Oracle8 case sensitivity

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Sat, 11 Apr 1998 01:46:14 GMT
Message-ID: <6gmi1v$9kk@bgtnsc03.worldnet.att.net>

On Thu, 09 Apr 1998 12:25:56 -0700, Jim Haran <jharan_at_wave.netREMOVE_THIS> wrote:

>I have Oracle8 for NT. Does anyone know of a configuration parameter
>that would make the database case insensitive as far as SQL statements
>are concerned?

No, there is no "case insensitive" parameter. You can either write your query as:

	select * from dept
 	where upper(dept_name) like upper('d%');

which has performance implications because it will force a table scan, or you can keep two copies of the column in your table. One copy in upper/lower case for readibility, and another in upper case only for querying. Received on Fri Apr 10 1998 - 20:46:14 CDT