db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Farukh S. Najmi" <farr...@wellfleetsoftware.com>
Subject Re: case insensitive searches
Date Wed, 09 Aug 2006 23:27:08 GMT
Stephen Caine wrote:

> 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

You can also use UPPER function in your query predicate as in:

... AND UPPER(name) = 'CAINE' ....

-- 
Regards,
Farrukh

Web: http://www.wellfleetsoftware.com
Blog: http://farrukhnajmi.blogspot.com


Mime
View raw message