From derby-user-return-4847-apmail-db-derby-user-archive=db.apache.org@db.apache.org Wed Aug 09 23:24:57 2006 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 61761 invoked from network); 9 Aug 2006 23:24:57 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 9 Aug 2006 23:24:57 -0000 Received: (qmail 2329 invoked by uid 500); 9 Aug 2006 23:24:55 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 2299 invoked by uid 500); 9 Aug 2006 23:24:55 -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 2288 invoked by uid 99); 9 Aug 2006 23:24:55 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Aug 2006 16:24:55 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE,SPF_HELO_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [65.170.183.31] (HELO powersrvcs.com) (65.170.183.31) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Aug 2006 16:24:53 -0700 Received: from [10.0.1.2] (24.62.209.251) by powersrvcs.com with ESMTP (Eudora Internet Mail Server 3.2.9) for ; Wed, 9 Aug 2006 19:24:29 -0400 Mime-Version: 1.0 (Apple Message framework v752.2) In-Reply-To: <20060809212132.58743D8022@xbox00.csee.siteprotect.com> References: <20060809212132.58743D8022@xbox00.csee.siteprotect.com> Content-Type: multipart/alternative; boundary=Apple-Mail-8-757967730 Message-Id: <0884256A-7C88-4BA2-B43E-53DFAFC795F2@commongrnd.com> From: Stephen Caine Subject: Re: case insensitive searches Date: Wed, 9 Aug 2006 17:27:06 -0400 To: "Derby Discussion" X-Mailer: Apple Mail (2.752.2) X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N --Apple-Mail-8-757967730 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed 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 --Apple-Mail-8-757967730 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=ISO-8859-1 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.
=A0
Are you = using 'starts with', 'contains' or 'equals'?=A0 These operators tend to = be case sensitive.=A0 Can you use 'like'?=A0 This is case = insensitive.

Stephen = Caine
Soft Breeze Systems, LLC
= --Apple-Mail-8-757967730--