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

[Jonathan Eric Miller]

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" <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
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