Latin1_General_CI_AS_KS_WS collation for Sharepoint

Question

_{Monday, August 29, 2016 12:53 PM}

Does the SQL Server need to be installed using the Latin1_General_CI_AS_KS_WS collation or would it be enough to set the model database collation to Latin1_General_CI_AS_KS_WS for the creation of the SharePoint databases?

All replies (2)

_{Monday, August 29, 2016 1:26 PM ✅Answered}

See this KB article for more information: https://support.microsoft.com/en-us/kb/2008668

The following TechNet Article talks about the SQL Server collation for the SharePoint databases
http://technet.microsoft.com/en-us/library/cc288970.aspx#section1

“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 instance (for master, tempdb databases). However we recommendusing Latin1_General_CI_AS_KS_WS as the instance default collation (master, tempdb databases).

Nico Martens
SharePoint/Office365/Azure Consultant

_{Wednesday, August 31, 2016 9:59 AM}

Hi pellet88,

If the reply is helpful to you, you could mark the reply as answer. Thanks for your understanding.

Best regards,

Sara Fan

Please remember to mark the replies as an answers if they help and unmark them if they provide no help.
If you have feedback for TechNet Subscriber Support, contact [email protected]