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:[EMAIL PROTECTED] > Sent: Thursday, March 03, 2005 3:20 AM > To: [email protected] > 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 > > >
