db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alan Burlison <Alan.Burli...@sun.com>
Subject Re: any feedback on this?
Date Mon, 23 Jun 2008 23:52:14 GMT
Bryan Pendleton wrote:

> 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.

That's what I thought, thanks for the confirmation.  One question: if I 
use something like
  	where upper_col = UPPER(?)
will Derby still use an index, or should I convert the case of the 
search term externally then do
	 where upper_col = ?

Alan Burlison

View raw message