db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Devang" <dev...@molecularconnections.com>
Subject RE: Case Sensitive
Date Fri, 04 Mar 2005 04:05:53 GMT
Suppose a table contain a same name with different case. How to retervie
that all records from table.
I hope u understand the question.

Thanx

Devang

-----Original Message-----
From: Bernd Ruehlicke [mailto:BRuehlicke@lgc.com]
Sent: Thursday, March 03, 2005 8:15 PM
To: Derby Discussion
Subject: RE: Case Sensitive


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