Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 39075 invoked from network); 3 Mar 2005 16:22:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 3 Mar 2005 16:22:22 -0000 Received: (qmail 3856 invoked by uid 500); 3 Mar 2005 16:22:21 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 3824 invoked by uid 500); 3 Mar 2005 16:22:21 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Development" Delivered-To: mailing list derby-dev@db.apache.org Delivered-To: moderator for derby-dev@db.apache.org Received: (qmail 40465 invoked by uid 99); 3 Mar 2005 09:10:55 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (hermes.apache.org: local policy) From: "Devang" To: Subject: Case Sensitive Date: Thu, 3 Mar 2005 14:41:46 +0530 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hi My application using derby database as an embedded database. So while configuring the database, I found the case sensitivity problem. Let me explain further, i.e. my db contains one table with fields name, address, city, street. So I inseted three records with name as "DEVANG" , "devang" , "Devang". When I tried to search name as DEVANG with 'LIKE' , then it reterived the single record. It would be nice, if I great an appropriate solution for this problem. Thanx Devang Gandhi