db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernd Ruehlicke" <BRuehli...@lgc.com>
Subject RE: Case Sensitive
Date Thu, 03 Mar 2005 14:44:39 GMT
I don't understand. 

LIKE 'DEVANG'  should give 1 row
LIKE 'D%' should give 2 rows
LIKE 'd%' should give 1 row

so to me the system did what you asked it to do - or have I
misunderstood you ?

B-)

> -----Original Message-----
> From: Devang [mailto:devang@molecularconnections.com] 
> Sent: Thursday, March 03, 2005 3:20 AM
> To: derby-user@db.apache.org
> Subject: Case Sensitive
> 
> 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
> 
> 
> 

Mime
View raw message