Supportability regarding SQL Server collation for SharePoint databases and TempDB
Original KB number: 2008668
Supportability regarding SQL Server collation
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).