This post will be fore the purpose of documenting all my findings regarding Collations in SQL Server, including changing the collation on an existing instance and the trade-offs.
|
1 2 3 4 |
SELECT name, COLLATIONPROPERTY(name, 'CodePage') AS Code_Page, description FROM sys.fn_HelpCollations() |
Changing the collation of a SQL Server 2012 database
Server Collation SQL_Latin1_General_CP1_CI_AS versus Latin1_General_CI_AS
Views – 1224