db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: any feedback on this?
Date Mon, 23 Jun 2008 23:45:29 GMT
> How do people work around this at present?  I absolutely *must* have 
> case-insensitive indexed searches in my application.

I store my critical string fields twice, in two separate columns, one
column has the user-desired case, and the other column has the same data
in all upper case.

Then, when I want to search without considering case, I take my search
terms, convert them to all upper case, and search against the upper-case column.

thanks,

bryan



Mime
View raw message