Thursday, June 9, 2016

SQL Server 2016 - Collation Defaults

For the US installation, the default database and analysis services collation defaults are as follows:

Database Engine:   SQL_Latin1_General_CP1_CI_AS

Analysis Services:  Latin1_General_CI_AS



2 comments:

Anonymous said...

Surely there's a mistake in the text - the illustration shows CS (case sensitive) not CI (case insensitive)...?

Andrew Peterson said...

Thanks for pointing this out!