db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jon Miller" <jemil...@uchicago.edu>
Subject Case insensitive indexed search possible?
Date Thu, 01 Nov 2007 22:52:41 GMT
Hi all,

Does anyone know if there is a way to do a case insensitive indexed search? 
I know in the past this wasn't possible, but, I'm wondering if this might 
not be fixed in the version that was recently released. Note, I know you can 
do a LOWER() to do it. However, I don't want to do that because I don't want 
it to do a table scan. Ideally, it would be possible to make all text 
searches case insensitive with a single setting.


View raw message