Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 sql server case sensitive?????????

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2006-08-31 : 01:01:39
hi friends, is it possible to make sqlserver case sensitive?
i mean is there any options to set while installation?

thank you very much

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-08-31 : 01:45:13
change the collation to a case sensitive collation


KH

Go to Top of Page

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2006-08-31 : 02:06:43
the collation is like

sql_latin1_general_c

now how can i change the collation?
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-08-31 : 03:45:09
Change to collation with CS (Case Sensitive) and not CI (Case Insensitive)

refer to here on how to change it. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=46915


KH

Go to Top of Page
   

- Advertisement -