Reconfiguring SQL Collation for SharePoint (MOSS)

Posted: 17th September 2010 in SharePoint, SQL

The correct collation for SharePoint in the English speaking world is  Latin1_General_CI_AS_KS_WS. However, if your collation is not set to this is can be changed by running the command below.

Note: Don’t make the mistake I did! The Instance name is not the name of the server, but the actual instance. This is MSSQLSERVER by default.

image

Advertisements
Comments
  1. Ayoub Umoru says:

    Hello Gordon,

    changing the collation of a SharePoint 2007 Database is not supported by Microsoft.

    You can change the collation of your SQL instance – they recommend to use SQL_Latin1_General_CP1_CI_AS, but you can change it to any other CI collation.

    Changing the collation for an existing instance is another topic.

    If you change the collation of the SharePoint 2007 Databases – you can lose Farm Support – that means if you break something, you are on your own.

    • Fair comment, but in this instance I was configuring a SQL instance to use SharePoint, not convert an existing farm.

      • John-Rock says:

        There is a common confusion when it comes to selecting the collation for SharePoint. According to http://support.microsoft.com/kb/2008668, when installing SQL the default collation should be SQL_Latin1_General_CP1_CI_AS for the server, but the databases for SharePoint should be configured for case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive. If you let SharePoint create these databases it will automatically choose the proper collation, and that you only need to worry about choosing this collation if you are manually creating the databases such as outlined in the article Deploy by using DBA-created databases (SharePoint server 2010).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s