Quote Originally Posted by Focus View Post
Perhaps it is version dependent but this

https://docs.microsoft.com/en-us/sql...l-server-ver15

Seems to suggest the default is SQL_Latin1_General_CP1_CI_AS.

It does also say ....
The server collation is specified during SQL Server installation.
Andrew, I am sure this is region dependent. We would not have changed the default collation during the installation. This is an extract from the link Chuck posted.

Because the name start with SQL_, this is a SQL Server collation, not a Windows collation. These are definitely obsolete, even if not officially deprecated, and are mainly for pre-SQL Server 2000 compatibility. Although, quite unfortunately SQL_Latin1_General_CP1_CI_AS is very common due to it being the default when installing on an OS using US English as its language. These collations should be avoided if at all possible.

Windows collations (those with names not starting with SQL_) are newer, more functional, have consistent sorting between VARCHAR and NVARCHAR for the same values, and are being updated with additional / corrected sort weights and uppercase/lowercase mappings
And this isn't the first time I've read that the SQL_ versions are considered obsolete.