The only remaining useful feature of FTS in a case-insensitive DBMS would be for searching on diary fields. Rick _____
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Friday, September 14, 2007 10:19 AM To: [email protected] Subject: Re: Case Sensitive searches ** One last question and then I'll stick my head back into my monitor. AR System setup on MS SQL would also not require FTS? There maybe additional benefits to FTS but searching character fields greater than 2000 characters on MS SQL still returned results. It was only on Oracle that required FTS to search large character fields. Thanks, Dave _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Friday, September 14, 2007 1:05 PM To: [email protected] Subject: Re: Case Sensitive searches ** Ah - yes, then. SQL is case-insenstive. Rick _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Friday, September 14, 2007 9:56 AM To: [email protected] Subject: Re: Case Sensitive searches Sorry the question was supposed to be asked for MS SQL instance. ------Original Message------ From: Rick Cook To: Arslist ReplyTo: Arslist Sent: Sep 14, 2007 12:52 PM 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 ------Original Message Truncated------ Dave -------------------------- [EMAIL PROTECTED] (Wireless) __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
