Things to consider when you configure collation settings for SQL Server 2000 databases or SQL Server 2005 databases that are used by SharePoint Portal Server 2003, by SharePoint Server 2007, and by Windows SharePoint Services

Article translations Article translations
Article ID: 843578 - View products that this article applies to.
Expand all | Collapse all

INTRODUCTION

This article discusses things to consider when you configure collation settings in Microsoft SQL Server 2000 or in Microsoft SQL Server 2005 for the databases that are used by Microsoft Office SharePoint Server 2007, by Microsoft Office SharePoint Portal Server 2003, and by Microsoft Windows SharePoint Services.

MORE INFORMATION

The physical storage of character strings in SQL Server 2000 and in SQL Server 2005 is controlled by collations. A collation specifies the bit patterns that represent each character and specifies the rules that are used to sort and compare characters.

Use the Latin1_General_CI_AS_KS_WS collation for SharePoint Portal Server 2003 databases and for Windows SharePoint Services 2.0 databases. SharePoint Portal Server 2003 and Windows SharePoint Services use the Latin1_General_CI_AS_KS_WS collation because the Latin1_General_CI_AS_KS_WS collation most closely matches the Microsoft Windows NTFS file system collation.

The following are characteristics of the collation that is used by SharePoint Portal Server 2003 and by Windows SharePoint Services 2.0:
  • Case insensitive
  • Accent sensitive
  • Kana sensitive
  • Width sensitive
Note SharePoint Portal Server 2003 and SharePoint Server 2007 will automatically create databases with the correct collation settings. Notice that the collation settings apply to the database level, but not to the SQL Server level.

REFERENCES

For additional information about how to transfer a database from one collation to another collation in SQL Server 2000, click the following article number to view the article in the Microsoft Knowledge Base:
325335 How to transfer a database from one collation to another collation in SQL Server
For more information about how to troubleshoot a collation issue in SharePoint Portal Server 2003 and in Windows SharePoint Services 2.0, click the following article number to view the article in the Microsoft Knowledge Base:
832814 You receive an "Error accessing database" error message and other error messages when you try to create a SharePoint Portal Server 2003 or a Windows SharePoint Services configuration database
For additional information about collations in SQL Server 2000, visit the following Microsoft Web sites:
http://msdn2.microsoft.com/en-us/library/aa214408(SQL.80).aspx
http://msdn2.microsoft.com/en-us/library/aa174903(SQL.80).aspx
http://msdn2.microsoft.com/en-us/library/aa258237(SQL.80).aspx

Properties

Article ID: 843578 - Last Review: May 13, 2010 - Revision: 4.0
APPLIES TO
  • Microsoft Office SharePoint Server 2007
  • Microsoft Office SharePoint Portal Server 2003
  • Microsoft Windows SharePoint Services 3.0
  • Microsoft Windows SharePoint Services 2.0
  • Microsoft SharePoint Foundation 2010
  • Microsoft SharePoint Server 2010
Keywords: 
kbconfig kbtshoot kbprb KB843578

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com