SQL Case-sensitivity

Posted by on May 24, 2014 Leave a comment (0) Go to comments

Most SQL installations have default collation. i.e case insensitive or SQL_Latin1_General_CP1_CI_AS in SQL Server glossary.

It can be changed at server, DB or column levels.

How to check current collation?
SELECT SERVERPROPERTY (‘Collation’)

Uncategorized

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>