Supportability regarding SQL Server collation for SharePoint databases and TempDB

Original KB number:   2008668

The following article talks about the SQL Server collation for the SharePoint databases

Prepare the database servers (Windows SharePoint Services)

The SQL Server collation must be configured for case-insensitive. The SQL Server database collation must be configured for case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive. This is to ensure file name uniqueness consistent with the Windows operating system.

However, we do not support changing the default collation (Latin1_General_CI_AS_KS_WS) for SharePoint databases to any other collations (CI, AS, KS, WS).

We support any CI collation for the SQL Server instance (for master and tempdb databases). However we recommend using Latin1_General_CI_AS_KS_WS as the instance default collation (master and tempdb databases).