db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Terry Kilshaw" <te...@quantechsoftware.com>
Subject RE: case insensitive searches
Date Thu, 10 Aug 2006 18:09:38 GMT

I mean like in MySQL. You configure it for case insensitive searching and
that's it.

For example the following two SELECT statements return the same row, whose
actual value is 'jdoe':

select userID from tbl_personnel where userID = 'jdoe'
select userID from tbl_personnel where userID = 'JDOE'  

Most of the feedback so far seems to indicate that although cas-insensitive
searching can be done it Derby, it carries the penalty of not using indexes.


-----Original Message-----
From: Kristian.Waagan@Sun.COM [mailto:Kristian.Waagan@Sun.COM] 
Sent: Wednesday, August 09, 2006 3:20 PM
To: Derby Discussion
Subject: Re: case insensitive searches

Terry Kilshaw wrote:
> 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.

Hi Terry,

Could give us some more information on what kind of searches you are talking
about? Most importantly, what searching mechanism is being used.

Thank you,

> thanks,
> Terry

View raw message