Case Insensitive Java DB Search (Derby)

Question

I am using Derby and I cannot find a way to make case insensitive.

For example, I have a table that I am looking for that contains “Hello”, but I set a search query for “Hello”, and at the moment I will not get the result, but I want to.

I can not find the correct syntax for it.

Sarah

Answer 1

You can use the UPPER () or LOWER () SQL functions for both your search argument and the field, for example, in

SELECT * FROM mytab WHERE UPPER(lastname) = UPPER('McDonalds') 

Answer 2

The most common way to do this is to use the created columns. Here's a good entry from one of the Derby developers: http://blogs.oracle.com/kah/entry/derby_10_5_preview_generated