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?


View raw message