db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Scott <deni...@gmail.com>
Subject Re: Case Sensitive
Date Thu, 03 Mar 2005 09:38:15 GMT
Case-sensitivity is a feature.

How about using the UCASE or LCASE function in your predicate?

For example:

SELECT * FROM address WHERE UCASE(name) = 'DEVANG'

should return all three records in your example.

Dan


On Thu, 3 Mar 2005 14:49:49 +0530, Devang
<devang@molecularconnections.com> wrote:
> 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