From jackrabbit-dev-return-3073-apmail-incubator-jackrabbit-dev-archive=www.apache.org@incubator.apache.org Mon Aug 01 13:35:22 2005 Return-Path: Delivered-To: apmail-incubator-jackrabbit-dev-archive@www.apache.org Received: (qmail 3495 invoked from network); 1 Aug 2005 13:35:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 1 Aug 2005 13:35:22 -0000 Received: (qmail 6551 invoked by uid 500); 1 Aug 2005 13:34:52 -0000 Mailing-List: contact jackrabbit-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: jackrabbit-dev@incubator.apache.org Delivered-To: mailing list jackrabbit-dev@incubator.apache.org Received: (qmail 6524 invoked by uid 99); 1 Aug 2005 13:34:52 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Aug 2005 06:34:52 -0700 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=INFO_TLD,RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of fgiust@gmail.com designates 64.233.182.194 as permitted sender) Received: from [64.233.182.194] (HELO nproxy.gmail.com) (64.233.182.194) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Aug 2005 06:34:37 -0700 Received: by nproxy.gmail.com with SMTP id x4so265612nfb for ; Mon, 01 Aug 2005 06:34:42 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=BdUHq54hAFVC0pYpBuwT/x16eHpLb2jS2or2cXyDc+bkjoRlz3nQHklfYkasDqIOo4FBTRu/GaBiNlCki8+RY9oHIJntJ3wSRRCIG9Wj66LZt9z0ajr5pf2GYu1fS7vVODbr1LXNdVXINC63a3NSDX3REiaaR0P6+RCbTaat+BE= Received: by 10.48.237.12 with SMTP id k12mr178254nfh; Mon, 01 Aug 2005 06:34:42 -0700 (PDT) Received: by 10.48.237.18 with HTTP; Mon, 1 Aug 2005 06:34:42 -0700 (PDT) Message-ID: <52e4c93f05080106346a2ace63@mail.gmail.com> Date: Mon, 1 Aug 2005 15:34:42 +0200 From: Fabrizio Giustina Reply-To: Fabrizio Giustina To: jackrabbit-dev@incubator.apache.org Subject: Re: search: support of not like and case insensitive search In-Reply-To: <96af23e47fb22c5fbd3e82cc822f1146@obinary.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <96af23e47fb22c5fbd3e82cc822f1146@obinary.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi Philipp! On 8/1/05, Philipp Bracher wrote: > hi list, >=20 > i use jackrabbit in the cms project magnolia. Using the search facility > I found two problems I was not able to solve: >=20 > 1) search seams to be case sensitive (xpath and sql syntax) > using LIKE 'test' and LIKE 'Test' is not returning the same result. Is > there a way to make the like function case insensitive? You should look at the magnolia source code for an example of case-insensitive queries ;) Look at http://svn.magnolia.info/view/magnolia/trunk/src/main/info/magnolia/cms/tag= libs/util/SimpleSearchTag.java?rev=3D1261&view=3Dmarkup it uses jcr:contains instead of like for queries cheers fabrizio