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.
| Author |
Topic |
|
rfleming
Starting Member
9 Posts |
 Posted - 2005-11-02 : 18:06:48
|
| is there are way to set SQL to only accept case sensitive syntax queries in query analyzer?I'm on a client's QA now and it is making me type Name.MEMBER_TYPEinstead of Name.member_typewhich i can do on my sql with no problem. I didn't realize you could set it to be case sensitive. How do you do that? |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2005-11-03 : 01:37:43
|
| Hi, When you have the Collation of BIN, then you will need to type in same Caps for the column name.Rgds, |
 |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2005-11-03 : 02:10:01
|
| Set the colation name to %_CS_% for example Latin1_General_CS_AS, Lithuanian_CS_AS.CS Stands for Case sensitive and CI in collation name stands for Case Insensitive.RegardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-03 : 08:23:35
|
Your client's database (and proably their server too) has been set up as case sensitive. That applies to all object names, as well as data.Daft choice IMHO  Kristen |
|
|
|
|
|
|
case sensitive queries