Sharepoint 2010 Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint 2010       RSS Feeds

SQL Server collation

  Asked By: Anushka    Date: Oct 05    Category: Sharepoint 2010    Views: 3571

I have always been told that the SQL Server collation setting is critical
to a SharePoint deployment.
Our standard is SQL_Latin1_General_CP1_CI_AS
SharePoint Server 2010 specifies Latin1_General_CI_AS_KS_WS
I would like to know if deviations are allowed and supported by Microsoft
Support Teams?



2 Answers Found

Answer #1    Answered By: Mason Davis     Answered On: Oct 05

I have been told that the collation sequence is critical for SharePoint Server
software deployments and I followed them exactly as stated by Microsoft.

What I would like to know is how critical is it and whether deviations to the
collation are supported.

My company's default is: SQL_Latin1_General_CP1_CI_AS

SharePoint Server 2010 requires: Latin1_General_CI_AS_KS_WS

Answer #2    Answered By: Savannah Pena     Answered On: Oct 05

Not 100% sure on SharePoint 2010, but on SharePoint 2007 it will simply not
allow you to attach a Content database that does not have the
Latin1_General_CI_AS_KS_WS, it will say something along the lines of "Error
you need to use the proper collation". If SharePoint creates the database,
it will obviously create it with the proper collation setting.

Assuming 2010 is the same as 2007, I don't see how you're going to get
around this one.

If your company is that strict, good luck with the rest of your deployment.
Every "standard" (like only DBAs creating databases, nobody getting SQL
Security Admin rights, etc.) got exercised during our SharePoint deployment.

Didn't find what you were looking for? Find more on SQL Server collation Or get search suggestion and latest updates.