none
SQL Server Collation for SharePoint 2016 RRS feed

  • Question

  • Hi Guys,

    I have been hearing from blogs and online that installing SharePoint with sql server as Latin1_General_CI_AS_KS_WS collation is the best practice 

    https://nikpatel.net/2013/09/05/use-latin1_general_ci_as_ks_ws-collation-for-sharepoint-database-engine/
    https://support.microsoft.com/en-us/help/2008668/supportability-regarding-sql-collation-for-sharepoint-databases-and-tempdb

    When we installed SQL Server by default SQLcollation chosen is Latin1_General_CI_AI  but when the sharepoint is installed all the content database are automatically choosing the collation Latin1_General_CI_AS_KS_WS .

    Does this cause any issue ? Do i have to re-install my SQL Server for SharePoint to follow best practice ?

    Take note tempDb is also in collation Latin1_General_CI_AI


    Ready for Action


    Monday, May 8, 2017 1:50 PM

All replies

  • The key here can be found in the line in the Support article that says:

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

    The standard default is supported for the system databases like master and tempdb.  The alternate collation is only required for SharePoint content databases and will automatically be applied by SharePoint when those content databases are created.  So there is no issue caused by having the default collation set the way it is and I wouldn't re-install or change your settings to modify the collation on the system databases at this point.  Its not necessary and if done wrong could cause problems for your entire environment.


    Paul Stork SharePoint Server MVP
    Principal Architect: Blue Chip Consulting Group
    Blog: http://dontpapanic.com/blog
    Twitter: Follow @pstork
    Please remember to mark your question as "answered" if this solves your problem.

    Monday, May 8, 2017 2:30 PM
  • Hi guys,

    Doesn't this different collation between system databases and Sharepoint databases cause performance issues?

    Wednesday, August 22, 2018 9:12 AM
  • Hi guys,

    Doesn't this different collation between system databases and Sharepoint databases cause performance issues?

    No - it will not cause any issues. You can install with default selection and SharePoint will take care of its own databases during the configuration. 
    Sunday, March 24, 2019 5:04 AM