Post reply

Collations

  • July 28, 2009 at 3:58 pm

    #208794

    Hi,

    We have SQL Server 2005 Enterprise edition 64 bit with SP3 and it has Share Point Databases in it. We have separate servers for SQL Server & Share Point.

    1.When we installed SQL Server Instance, we selected the default collation settings “SQL_Latin1_General_CP1_CI_AI”

    2.When the Share point Admin Installed Share point, it created databases on SQL Server instance with share point databases default collation settings “Latin1_General_CI_AS_KS_WS”

    3.Now every thing is in production with above collation settings and we did not get any issues.

    4.Recently, I had attended Microsoft teched, and people over there told me that, having default SQL Server collations (SQL_Latin1_General_CP1_CI_AI) and share point databases, created from Central Administration, default collations (Latin1_General_CI_AS_KS_WS) works perfectly with out any issues.

    5.We want to use the Same SQL Server instance to host other application, NOT share point related, which will work fine with default SQL Server collations “SQL_Latin1_General_CP1_CI_AI”.

    I would like to know the experts opinion , experience & suggestions

    Thanks

    Ram

  • July 28, 2009 at 7:38 pm

    #1031421

    Hi Ram

    My understanding is Collation "SQL_Latin1_General_CP1_CI_AI" is a collation that is used for backward compatibility with older SQL server version, I did a research to find out which collation should we've used as a default collation and Collation "Latin1_General_CI_AS" is the one that should be used going forward.

    However I have not used this collation with Sharepoint installation as I understand collation "Latin1_General_CI_AS_KS_WS" is used for mostly reporting areas, i.e. Reporting Server.

    Good Luck

    IT

  • July 29, 2009 at 12:38 am

    #1031478

    Hi Irwan Tjanterik,

    Are you maintaining share Point databases in SQL Server 2005? If yes please check the MASTER database collations (Master->Properties->collations) and any share point database on that instance and Post here.

    thanks

  • July 29, 2009 at 11:03 am

    #1031896

    Could you please give suggestions...

  • July 29, 2009 at 4:58 pm

    #1032074

    Hi Ram

    Unfortunately, I don't have any sharepoint database, I am sure you can always find out the default collation used by Sharepoint since you have it installed.

    IT

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply