db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Caine <step...@commongrnd.com>
Subject Re: case insensitive searches
Date Wed, 09 Aug 2006 21:27:06 GMT
Terry,

> Is it possible to set Derby to do case-insensitive searches? The  
> default seems to be case-sensitive. This would be fine as a global  
> setting that never needs to change.
>
Are you using 'starts with', 'contains' or 'equals'?  These operators  
tend to be case sensitive.  Can you use 'like'?  This is case  
insensitive.

Stephen Caine
Soft Breeze Systems, LLC
Mime
View raw message