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.