You need to set the collation sequence when installing SQL if you want it to be case sensitive. Otherwise, I believe it defaults to case-insensitive. You can run it as case-insensitive and enforce it as needed, when needed. One method we use is via direct SQL to call stored procedures with collation sequence enforced at the procedure level (can be turned on and off as needed).
Recommend you check the SQL Books Online. Craig Carter, RSP ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Friday, September 14, 2007 10:53 AM To: [email protected] Subject: Re: Case Sensitive searches Yes, *** IF *** the DB was set up that way. Just because 10G and above CAN be set that way doesn't mean that they WERE set up that way. Talk to your DBAs. Rick ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Friday, September 14, 2007 9:46 AM To: [email protected] Subject: Re: Case Sensitive searches We're running on Oracle. Asking the question for one of our other divisions that just setting up on MS SQL. So a search for 'field' = "bmc" should return data where the field was set to BMC, Bmc, or bmc. ------Original Message------ From: Rick Cook To: Arslist ReplyTo: Arslist Sent: Sep 14, 2007 12:35 PM Subject: Re: Case Sensitive searches ** SQL is, by default, a case-insensitive DBMS, and has been for the past several versions. I don't even know how to set it up any other way, or why someone would want to. The last major DBMS to not be like this was Oracle - I think 9i was the last one that could not be easily set up case-insensitive. Rick ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Friday, September 14, 2007 9:25 AM To: [email protected] Subject: Case Sensitive searches ** I know this has been answered before. My searches just haven't found the answer on the ARS List or BMC/Remedy Support. If I remember correctly, the AR System can be set up on MS SQL in a manner that searches are not case sensitive. If I remembered correctly what steps need to be taken to set up MS SQL correctly. Also if I remember correctly FTS is not really needed on an AR System running MS SQL. Is my memory correct or am I just having a bad day? Thanks, Dave Dave Shellman Phone: (717) 810-3687 Fax: (717) 810-2124 email: [EMAIL PROTECTED] Tyco Electronics MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ Dave -------------------------- [EMAIL PROTECTED] (Wireless) __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
