Case-Insensitive Queries in Derby???
posted 9 years ago
I am new to Derby (Cloudscape), coming from SQL Server, and I am having trouble with case sensitivity on queries. A query such as Select * From Customers Where Customer = 'FRED' is different than Select * From Customers Where Customer = 'fred'. I know I can use the lower() function to get the proper results, but it is too slow on a large table. Is there a way to set something globally that makes all queries case-insensitive? You help is much appreciated.