Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 57910 invoked from network); 19 Jul 2007 04:29:25 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 19 Jul 2007 04:29:25 -0000 Received: (qmail 89234 invoked by uid 500); 19 Jul 2007 04:29:06 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 89203 invoked by uid 500); 19 Jul 2007 04:29:06 -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 89189 invoked by uid 99); 19 Jul 2007 04:29:06 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 Jul 2007 21:29:06 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of denials@gmail.com designates 64.233.162.236 as permitted sender) Received: from [64.233.162.236] (HELO nz-out-0506.google.com) (64.233.162.236) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 Jul 2007 21:29:03 -0700 Received: by nz-out-0506.google.com with SMTP id m7so349544nzf for ; Wed, 18 Jul 2007 21:28:42 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=NClX3GzU6PH6tKwQJHz0iYXi6c29FF78TT7vanw9bhncOn7gVB07e/lGw7T9UnZ0szFqj9xRclngj6wJeMx+TJRXF1a1+Z7+TJd1smKgrZ6V+zcgAxI5IKPhWLHelRNAHohGMGRv2X4Mf9wTeJHMBMvr99emYsxGm84b1uzRMtA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ECGxHDDV/Vu2Q2Xu9yDtun7vqt+R5G4KZoPuGL9wgXEOH9LyDjPb8/iePCEF9bvP3cP5L5G3ZelLsnzJxcLllIrWihrx9aKs5et7xu+tN/wHI/GINNYHiPEbhmvjSgqsTdpBu87rNCZjHsqAgrSQDsjyi0wxKQK1MLCmE4tlCVI= Received: by 10.142.234.12 with SMTP id g12mr182873wfh.1184819322216; Wed, 18 Jul 2007 21:28:42 -0700 (PDT) Received: by 10.142.80.14 with HTTP; Wed, 18 Jul 2007 21:28:42 -0700 (PDT) Message-ID: Date: Thu, 19 Jul 2007 00:28:42 -0400 From: "Dan Scott" To: "Derby Discussion" Subject: Re: case-insensitive In-Reply-To: <469EB456.1060802@0nur.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <469EB456.1060802@0nur.net> X-Virus-Checked: Checked by ClamAV on apache.org On 18/07/07, Onur Aslan wrote: > Hi. I am using Apache Derby and i am newbie. I have a problem. I am > select some rows with: > > "SELECT * FROM parcalar WHERE parca_no LIKE '%onur%'" > > But this query is select case-insensitive parca_no values. Like if > parca_no = Onur this query isn't select this row. I want to disable case > insensitive. How can i do this? > "SELECT * FROM parcalar WHERE LCASE(parca_no) LIKE '%onur%'" ... should do the trick, although it may be slower than you want. -- Dan Scott Laurentian University