SQL Server Collation

A collation specifies the bit patterns that represent each character and the rules by which characters are sorted and compared.


Instead of just right clicking on SSMS , these are some alternatives to locating SQL Server Collation information I use.

--To find all collations available

SELECT * FROM fn_helpcollations()




--To find the SQL Server Collation level

select SERVERPROPERTY('collation')




--To find the database collation level

SELECT DATABASEPROPERTYEX('MyDatabase', 'Collation') as DB_SQLCollation;