Kristian, 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. Terry -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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, -- Kristian > > thanks, > > Terry
