db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jon Miller" <jemil...@uchicago.edu>
Subject Possible to configure Derby for case-insensitive compares by default?
Date Mon, 12 Mar 2007 17:33:26 GMT
Hi all,

I'm wondering if anyone knows if it's possible to configure Derby so that 
searches on CHAR/VARCHAR fields are case insensitive by default?

I'm guessing that if the answer is no, the solution is to just do a LOWER() 
or similar on the field and compare it that way. I'm guessing if you do that 
though, it won't use the index if the field is indexed?

Jon


Mime
View raw message