Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

SharePoint and SQL Server Database Collation

Asked By: Lukas Nolan Date: Jun 11, 2005 Category: Sharepoint Views: 367

When SPS is deployed on SQL Server the default Collations settings for the databases within the SQL Server is "Latin1_General_CI_AS_KS_WS".

This is ok if this collations settings are used as a default for the SQL Server. In my enviroment the default settings for the SQL Server Collation is "Icelandic_CI_AS". So I have a problem. Every time I create a query joining two databases together I get a collation error. I can work around it but it slows everything down.

My question is : Is there a way to deploy SPS so it will use the default SQL Servers Collation settings ("Icelandic_CI_AS") instead of predefined ("Latin1_General_CI_AS_KS_WS")?

I know this is an issue here in Europe. We do use different collation settings, i.e. danish, sweedish, finish, german, etc..

Tagged:sharepoint and sql server database collation

1 Answer Found

Answer #1 Answered By: Matt Prince Answered On: Jun 11, 2005

I know this doesn't solve your problem, but I thought it might be of
interest if you haven't already seen it:

"...SharePoint Portal Server 2003 requires that the collation name
for the database be Latin1_General_CI_AS_KS_WS. This name most
closely matches the Microsoft Windows NTFS file system collation."
--http://support.microsoft.com/kb/832814/

This article also has some interesting details:
support.microsoft.com/default.aspx

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