db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Catteeuw Peter" <Peter.Catte...@realsoftwaregroup.com>
Subject Query and uppercases
Date Wed, 26 Apr 2006 12:28:14 GMT
Hello,

 

could anyone help me with the following problem:

 

When I do a SELECT query and I search for e.g. "Detroit" but the data in
the derby db is "detroit" then the query has no results.

Is there a way to bypass this, so when querying the database it does not
look at uppercases or lowercases. ==> Detroit = detroit = dEtRoIt = ...

 

Help would be appreciated.

 

Thx,

Peter


Mime
View raw message