Quite correct, Roger. SQL is case-INsensitive by default. I misread her question.
Rick -----Original Message----- From: "Chowdhury, Tauf" <[email protected]> Date: Thu, 25 Mar 2010 12:27:11 To: <[email protected]> Subject: Re: Case Sensitivity in Remedy FYI, It is recommended by DBA and BMC to not use the case insensitivity feature in Oracle. It's possible to take a 50% performance hit with it enabled. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Nall, Roger Sent: Thursday, March 25, 2010 12:21 PM To: [email protected] Subject: Re: Case Sensitivity in Remedy ** I think Rick might be thinking of Oracle. SQL is by nature case insensitive where as Oracle is case sensitive. I believe there is a setting in Oracle at the time of install to make Oracle case insensitive. Of corse I am not a DBA and could very well not have a clue as to what I am talking about. HTH, Roger Nall Manager, SA Business Intelligence/Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 http://saintake.t-mobile.com/interfaces/default.aspx From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick Cook Sent: Thursday, March 25, 2010 11:16 AM To: [email protected] Subject: Re: Case Sensitivity in Remedy ** That is a database setting. Usually is is only configurable at install time. Rick ________________________________ From: Kathy Morris <[email protected]> Date: Thu, 25 Mar 2010 12:09:35 EDT To: <[email protected]> Subject: Case Sensitivity in Remedy Hi, Is there any way to configure Remedy 7.x to be case insensitive We are on a SQL database. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ********************************************************************** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
