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



Posted by at
Labels: ,

2 comments:

Anonymous said...

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

September 6, 2018 at 7:20 AM
Andrew Peterson said...

Thanks for pointing this out!

September 10, 2018 at 5:37 PM

Post a Comment

Subscribe to: Post Comments (Atom)