Win a copy of The Business Blockchain this week in the Cloud forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Case-Insensitive Queries in Derby???

 
Michael Bunch
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 531
Java Mac OS X Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Michael Bunch
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for your reply. I will try to post a feature request with them. It is certainly needed.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic