Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SharePoint and SQL Server Database Collation

  Asked By: Lukas    Date: Jun 11    Category: Sharepoint    Views: 2406

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..



1 Answer Found

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

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."

This article also has some interesting details:

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

Related Topics:



Related Post