Collation in SQL Server


Collation determines how the data should be stored. This stored data can be retrieved in the same format for any execution or compare operation.

Collation can determine options like Case sensitive, Accent Sensitive etc.  We can find the collation which the database is assigned by  using the following query.

select name,collation_name from sys.databases



Collation in SQL Server was last modified: October 1st, 2017 by Justin Antony