db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Eric Miller" <jemil...@uchicago.edu>
Subject Re: How to configure Derby to be case-insensitive?
Date Tue, 25 Jan 2005 19:00:30 GMT
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" <mikem_app@sbcglobal.net>
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


Mime
View raw message