Re: How to configure Derby to be case-insensitive?

[Jonathan Eric Miller]

Yeah, that's what I was thinking. I was thinking that maybe I could do 
something like the following, but, that doesn't appear to be possible. 
Neither, MySQL or MSSQL seem to be able to do that either, but, their 
searches are case insensitive by default.

CREATE INDEX firstName ON Person LOWER(firstName);
Jon
----- Original Message ----- 
From: "Mike Matrigali" <[EMAIL PROTECTED]>
To: "Derby Discussion" <derby-user@db.apache.org>
Sent: Tuesday, January 25, 2005 12:49 PM
Subject: Re: How to configure Derby to be case-insensitive?


I also believe there is no way to get derby to automatically do
case insensitive searching.
Someday I hope that someone builds indexes on a function in derby.
Building the index should not be too hard, I think the more
difficult/interesting work is to get the optimizer to choose the
index, and getting the execution engine to use the index.
Case insensitive search is one example of a feature which could be
addressed by functional indexes.
/mikem