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).
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for