tag:blogger.com,1999:blog-8290036970280400845.post4115316341486542531..comments2009-05-25T07:26:51.751-05:00Troy Lanphierhttp://www.blogger.com/profile/16863439719347647318t.lanphier@gmail.comBlogger3125tag:blogger.com,1999:blog-8290036970280400845.post-47018088752771675562009-05-25T07:26:51.751-05:002009-05-25T07:26:51.751-05:00Hi Troy. Does this mean that SharePoint has no support of collations other than general Latin1? This is not good when your main language calls for a different collation in sorting items. I'm from Denmark where the last three letters are "æ", "ø" and "å" - the collations DANISH_NORWEGIAN_XX_YY respect this while the Latin1 collation sorts the letters as variations of a, o and a respectively.Gyros.dkhttp://www.blogger.com/profile/05403823110170091395noreply@blogger.comtag:blogger.com,1999:blog-8290036970280400845.post-14509112796061246922009-02-27T11:02:25.361-06:002009-02-27T11:02:25.361-06:00Hi Satyam,<BR/><BR/>You did not specify what version of SQL you are using, but the problem still remains. Building any new databases from within SharePoint (Content DBs) may result in their having the wrong collation when they are created, which would create problems in the long run.<BR/><BR/>For this response, I am assuming that there are no other databases in this SQL instance (the one for SharePoint). I would follow the steps shown in this blog entry - http://blogs.digineer.com/blogs/jasons/archive/2007/10/18/change-sql-server-collation.aspx to rebuild the system databases to match the desired collation. Details on SharePoint and collation can be found at http://support.microsoft.com/kb/843578Troy Lanphierhttp://www.blogger.com/profile/16863439719347647318noreply@blogger.comtag:blogger.com,1999:blog-8290036970280400845.post-38436098764044967812009-02-09T11:35:25.517-06:002009-02-09T11:35:25.517-06:00Hi Troy Lanphier,<BR/>Greetings.<BR/>Sir I have a question which my DBA team has asked.<BR/><BR/>We noticed that the SQL Server instance for SharePoint databases has different collation settings for System databases and Share point databases.<BR/><BR/> <BR/><BR/>Collation settings for System databases (Default collation settings while installing SQL Server): SQL_Latin1_General_CP1_CI_AS<BR/><BR/>Collation settings for SharePoint databases (SharePoint will create automatically): Latin1_General_CI_AS_KS_WS.<BR/><BR/> <BR/><BR/>In general if we have different collation settings for system databases and user databases will we will get sorting issues. i would like to know what will be the impact of having different collation settings for SQL server and SharePoint databases.<BR/><BR/>The DBA Team is asking any type of documentation from Microsoft about the settings<BR/><BR/>Thank you for all the support, help and guidelines<BR/><BR/>do we really need to change the collation settings of system databases..to match the sharepoint databases?<BR/><BR/>Satyam.satyamhttp://www.blogger.com/profile/16063619613753304974noreply@blogger.com