• 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.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!