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


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.




View raw message