List database collation

From Robs_Wiki
Jump to: navigation, search


a Collation is a configuration that determines how character data sorting is done. This is an important setting that has a huge impact on how the SQL Server database engine behaves in dealing with character data

SQL Azure default collation

The default collation for character data in SQL Azure databases is SQL_Latin1_General_CP1_CI_AS.

SELECT CONVERT (varchar(256), SERVERPROPERTY('collation'));