Frank,
I don't know if you've heard of the Column Search product yet, but it allows you to do case-insensitive searches against your Oracle database (plus a whole lot more!!!). If you (or others!) are interested in learning more about it, go ahead and contact me and I can coordinate a demo of the product. Thank you! Matt Reinfeldt From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick Cook Sent: Monday, December 06, 2010 8:41 AM To: [email protected] Subject: Re: Oracle 11g and Case Insensitive Searches ** We have been told that FTS is the best solution. Setting Oracle to be case insensitive causes performance issues. Rick On Dec 6, 2010 7:50 AM, "Frank Caruso" <[email protected]> wrote: > ARS 7.6.3 > ITSM 7.6.3 > Solaris 10 64bit > Oracle 11g 64bit > > Looking to find out how others are handling case insensitive searches in > Oracle 11g? Or is FTS the way to go? > > Thank you > > Frank Caruso > > ____________________________________________________________________________ ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

