You can select the case sensitivity by changing the collation. You can change the collation of the entire database or only of a certain table. See http://msdn2.microsoft.com/en-US/library/ms144250.aspx http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=60020&SiteID=1
-- Michiel On 12/5/06, Rick Cook <[EMAIL PROTECTED]> wrote:
** I can't even remember seeing an option to install MS SQL as case-insensitve for at least a couple of versions. When it was there, it was still tied to Sybase (i.e. v6), where you simply selected a dataset that fit your needs, and selected your case sensitivity once and for all at that time. What version of SQL are you using? Rick On 12/5/06, CONDREA, Daniel <[EMAIL PROTECTED]> wrote: > ** > Is MSSQL really case insensitive? > > It depends how it installed. > > Here is case sensitive > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto:[email protected] > ] *On Behalf Of *Axton > *Sent:* 05 December 2006 17:10 > *To:* [email protected] > * Subject:* Re: Database > > > ** > Is MSSQL really case insensitive? > Yes > > > We have several stored procedures in ORACLE. How flexible is MSSQL > when it comes to stored procedures? > The stored procedures are very capable, but the code does not transport > between the two RMDBS systems you referenced. You will have to rewrite the > sp's. > > > I have heard many say the Windows is not as stable as UNIX. How stable > is MSSQL? > My personal experience has been that, on MS, the more you install, the > less stable the system becomes. In corp/institutional environments, this > roughly translates to, the more groups you have involved in managing your > servers, the less stable they are. In the shops where my group managed the > servers from the wall out, windows was rock solid. In the shops where there > was a storage group, an OS group, a security group, a hardware group, a > network group, an hp group, an oracle group, and many other groups involved > in the management of the system, the thing continually falls apart. > > Axton Grams > > On 12/5/06, David Yearsley <[EMAIL PROTECTED] > wrote: > > > > ** Our current environment has included a ORACLE database more than 6 > > years. Our hardware is reaching the end of its life and because of Price and > > the Case Sensitivity of ORACLE we are looking at possibly replacing ORACLE > > with Microsoft SQL. > > > > As we investigate this change there are several questions I would like > > to ask. > > > > Is MSSQL really case insensitive? > > > > > > We have several stored procedures in ORACLE. How flexible is MSSQL > > when it comes to stored procedures? > > > > > > I have heard many say the Windows is not as stable as UNIX. How stable > > is MSSQL? > > > > > > Has anyone made the switch from ORACLE to MSSQL? If so, do you have > > any advice? > > > > > > Any information we are overlooking? > > __20060125_______________________This posting was submitted with HTML > > in it___ > > > __20060125_______________________This posting was submitted with HTML in > it___ > __20060125_______________________This posting was submitted with HTML in > it___ > > > -- > > *****DISCLAIMER***** > > The information contained in this communication is confidential and may > be legally privileged. It is intended solely for the use of the individual > or entity to whom it is addressed and others authorized to receive it. If > you are not the intended recipient you are hereby notified that any > disclosure, copying, distribution or taking action in reliance of the > contents of this information is strictly prohibited and may be unlawful. > Orange Romania S.A. is neither liable for the proper, complete > transmission of the information contained in this communication nor any > delay in its receipt. > > *****END OF DISCLAIMER***** > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
