Hacker News new | ask | show | jobs
by p_ing 423 days ago
Collation in a database determines case sensitivity in MSSQL. If the collation has "cs", it's case-sensitive. If it has "ci", it is case-insensitive.

Collation is configurable at the server level, but usually one goes for a _CI_ collation there (not much reason for master to be _CS_). Each user database can have it's own collation/case-sensitivity.