If the DB is Oracle (which it must be as this problem is not quite relevant on MS-SQL), I have heard similar things from Oracle DBA’s as what Tauf mentioned.
However I have also heard that Oracle has changed the way things work around switching the database to case insensitive from 10g onwards. If you are on 9i below, you might want to be careful. So you may want to double check with the DBA’s on that one. Joe From: Tauf Chowdhury Sent: Monday, April 02, 2012 9:47 AM Newsgroups: public.remedy.arsystem.general 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]> 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 ARSlist: "Where the Answers Are"_ -- Tauf Chowdhury _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
