From derby-user-return-4856-apmail-db-derby-user-archive=db.apache.org@db.apache.org Thu Aug 10 18:33:52 2006 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 22579 invoked from network); 10 Aug 2006 18:33:51 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 10 Aug 2006 18:33:51 -0000 Received: (qmail 8866 invoked by uid 500); 10 Aug 2006 18:33:48 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 8794 invoked by uid 500); 10 Aug 2006 18:33:48 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 8767 invoked by uid 99); 10 Aug 2006 18:33:47 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 Aug 2006 11:33:47 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=RCVD_IN_BL_SPAMCOP_NET X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [64.41.126.163] (HELO fbr01.cseeplus.net) (64.41.126.163) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 Aug 2006 11:33:37 -0700 Received: from localhost (mf08-md.csee.chicago.hostway [192.168.20.45]) by fbr01.cseeplus.net (Postfix) with ESMTP id 9D8151442A5 for ; Thu, 10 Aug 2006 13:33:10 -0500 (CDT) Received: from TerryVaio (S010600001c529d5c.ok.shawcable.net [24.70.0.148]) by xbox00.csee.siteprotect.com (Postfix) with ESMTP id 83F46D8356 for ; Thu, 10 Aug 2006 13:06:53 -0500 (CDT) From: "Terry Kilshaw" To: "'Derby Discussion'" Subject: RE: case insensitive searches Date: Thu, 10 Aug 2006 11:09:38 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 Thread-Index: Aca8AfZP4yxHDQinT76s8d1WdPVFCAApOkWA In-Reply-To: <44DA5F79.8070508@Sun.com> Message-Id: <20060810180653.83F46D8356@xbox00.csee.siteprotect.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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: 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, -- Kristian > > thanks, > > Terry