FTS doesn't use the case. I'm not sure how they pulled that off but I tested this on a case-sensitive Oracle system back at the beginning of the year. Of course the bug with FTS not being able to search using "%string%" made searches appear to not work at all. For instance, using the search function on the SRM home page would not return anything with FTS enabled. Disable FTS and all the keywords will return fine.
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Tauf Chowdhury Sent: Monday, April 02, 2012 8:48 AM To: [email protected] Subject: Re: Changing case sensitivity ** Rick, >From talking with DBA's and reading some of BMC's info, changing case >sensitivity at the database level with Oracle is very taxing and you will >experience a huge degradation in performance. I have not tried it so don't >know but I've heard enough people discourage it to not recommend it. It has >something to do with how Oracle performs that function. You are better off >using FTS to index the fields that you don't want to be case sensitive... that >is of course once you get FTS working properly :) On Mon, Apr 2, 2012 at 9:39 AM, Rick Cook <[email protected]<mailto:[email protected]>> wrote: ** AR System/ITSM 7.5, Oracle 11g. Our system is set up as case sensitive, and FTS is installed and configured. What would the impact be to changing the setting on an existing system? Rick _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ -- Tauf Chowdhury _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

