Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 28596 invoked from network); 23 Jun 2008 23:47:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 23 Jun 2008 23:47:01 -0000 Received: (qmail 22358 invoked by uid 500); 23 Jun 2008 23:47:02 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 22328 invoked by uid 500); 23 Jun 2008 23:47:02 -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 22317 invoked by uid 99); 23 Jun 2008 23:47:02 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Jun 2008 16:47:02 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [63.82.107.6] (HELO red.edgility.com) (63.82.107.6) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Jun 2008 23:46:12 +0000 Received: from [127.0.0.1] (bp-laptop.edgility.com [10.10.12.212]) by red.edgility.com (8.13.8/8.13.8) with ESMTP id m5NNjT1e025211 for ; Mon, 23 Jun 2008 16:45:30 -0700 Message-ID: <48603599.9010807@amberpoint.com> Date: Mon, 23 Jun 2008 16:45:29 -0700 From: Bryan Pendleton User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: Derby Discussion Subject: Re: any feedback on this? References: <248012.88193.qm@web31807.mail.mud.yahoo.com> <485FB1AA.4060701@sun.com> <486034E1.4010408@sun.com> In-Reply-To: <486034E1.4010408@sun.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org > How do people work around this at present? I absolutely *must* have > case-insensitive indexed searches in my application. I store my critical string fields twice, in two separate columns, one column has the user-desired case, and the other column has the same data in all upper case. Then, when I want to search without considering case, I take my search terms, convert them to all upper case, and search against the upper-case column. thanks, bryan