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 Mon, 24 Jan 2005 16:25:40 GMT
I'm guessing that the answer to this is that you can't. So, I'm guessing you 
just use the LOWER() function like the following.

SELECT * FROM Person WHERE LOWER(firstName) = 'jonathan';

However, if you do this, then it won't use an index if you have an index on 
the column that you are filtering on, correct?

Jon

----- Original Message ----- 
From: "Jonathan Eric Miller" <jemiller@uchicago.edu>
To: "Derby User List" <derby-user@db.apache.org>
Sent: Monday, January 24, 2005 9:19 AM
Subject: Re: How to configure Derby to be case-insensitive?


> Does anyone know the answer to this?
>
> Jon
>
> ----- Original Message ----- 
> From: "Jonathan Eric Miller" <jemiller@uchicago.edu>
> To: "Derby User List" <derby-user@db.apache.org>
> Sent: Thursday, January 20, 2005 3:36 PM
> Subject: How to configure Derby to be case-insensitive?
>
>
>> Does anyone know if it's possible to configure Derby so that searches are 
>> case-insensitive?
>>
>> Jon
>>
> 


Mime
View raw message