Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 7579 invoked from network); 23 Jun 2008 14:02:00 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 23 Jun 2008 14:02:00 -0000 Received: (qmail 38520 invoked by uid 500); 23 Jun 2008 14:02:00 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 38494 invoked by uid 500); 23 Jun 2008 14:02:00 -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 38483 invoked by uid 99); 23 Jun 2008 14:02:00 -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 07:02:00 -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 [217.206.42.18] (HELO mail.optrak.co.uk) (217.206.42.18) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Jun 2008 14:01:11 +0000 Received: from mercury.net.optrak.co.uk ([192.168.41.65]) by mail.optrak.co.uk with Microsoft SMTPSVC(6.0.3790.3959); Mon, 23 Jun 2008 15:01:07 +0100 Received: from 192.168.41.61 ([192.168.41.61] helo=mercury.net.optrak.co.uk) by ASSP-nospam; 23 Jun 2008 15:01:07 +0100 Received: from [192.168.41.87] ([192.168.41.87]) by mercury.net.optrak.co.uk with Microsoft SMTPSVC(6.0.3790.3959); Mon, 23 Jun 2008 15:01:07 +0100 Message-ID: <485FACA3.40802@optrak.co.uk> Date: Mon, 23 Jun 2008 15:01:07 +0100 From: Mark Thornton 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> In-Reply-To: <248012.88193.qm@web31807.mail.mud.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 23 Jun 2008 14:01:07.0570 (UTC) FILETIME=[955B4D20:01C8D539] X-Virus-Checked: Checked by ClamAV on apache.org Geoff hendrey wrote: > I posted a comment with a suggestion on an approach for dealing with > case-insensitive comparisons. > > Any feedback? > https://issues.apache.org/jira/browse/DERBY-1748?focusedCommentId=12606166#action_12606166 > I find declaring the collation when defining the column is much more useful as it then automatically applies to all comparisions/indexes involving the column. Allowing more options when specifying the database collation would be a useful starting point (as suggested by Debrunner). Mark Thornton