Careful, FTS is only free on the newer pricing model/latest versions. Check with your BMC rep if you are entitled to use it without additional charge. You used to have to pay extra for it. Nate.
Nathan Aker ITSM Solution Architect McAfee, Inc. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of patchsk Sent: Tuesday, February 07, 2012 9:56 AM To: [email protected] Subject: Re: Case sentive In ITSM problem management ** The case sensitiveness is a limitation on the database. Oracle by default is case sensitive and you need to change its configuration to make it case insensitive, but you need to recreate your indices. You can do a search on this forum for more information if it is workable. However MS SQL server is case insensitive, so your queries would work in either case. With oracle I think you could use remedy FullTextSearch feature to run case insensitive queries for specific fields. And it is free feature to use. Otherwise as Tauf has suggested you need to convert the data to uppercase before saving the record and any time doing a query, convert the user entered data to uppercase to use with queries. With the newer versions of arsystem there is a type ahead feature you can enable case insensitive. See if it would be useful in your case. _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"
