*
The moose likes JDBC and the fly likes Case-Insensitive Queries in Derby??? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Case-Insensitive Queries in Derby???" Watch "Case-Insensitive Queries in Derby???" New topic
Author

Case-Insensitive Queries in Derby???

Michael Bunch
Ranch Hand

Joined: Jun 27, 2002
Posts: 31
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.
Masoud Kalali
Author
Ranch Hand

Joined: Jul 08, 2004
Posts: 531

Hi
there is no such feature in derby until 10.2.x .
Maybe you could open some RFE in JIRA, Derby team will address importatnt issues in each release.


Masoud Kalali
Software Engineer - My Weblog - GlassFish Security
Michael Bunch
Ranch Hand

Joined: Jun 27, 2002
Posts: 31
Thanks for your reply. I will try to post a feature request with them. It is certainly needed.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Case-Insensitive Queries in Derby???