2

After installing Sharepoint I realized that the collation of all Sharepoint databases is Latin1_General_CI_AS_KS_WS while my server collation is Latin1_General_CI_AS. From official documentation I see that all CI collations are supported. Anyway, would it be helpful for me to rebuild the system databases into the same collation to avoid conversion problems in temp db?

Quote

We support any CI collation for the SQL instance (for master, tempdb
databases). However we recommend using Latin1_General_CI_AS_KS_WS as the instance default collation (master, tempdb databases).

I don't find the best practice here, please help me.

  • 2
    I highly recommend that server collation and database collations are same. You will run into conversion problems sine SharePoint uses tempdb a lot. Please rebuild system databases and rerestore your user databases. – Kin Shah Oct 7 '15 at 12:16
1

Having a different default collation for the instance than for the SharePoint DB is not necessarily a problem. The main thing to ensure is that the SharePoint DB is set to the correct collation for SharePoint, which is Latin1_General_CI_AS_KS_WS, and which you have done.

You quoted a section from Supportability regarding SQL collation for SharePoint Databases and TempDB (in the future, when you quote something, you really need to attribute the source) which clearly states that SharePoint does indeed "support any CI collation for the SQL instance (for master, tempdb databases)". Hence, Latin1_General_CI_AS being case-insensitive, is supported.

The only other guidance I have found, and which makes sense, even outside of SharePoint, is this:

SharePoint SQL Collation - Best practice

The main point expressed there is that if you have more running on this instance of SQL Server than SharePoint, then sure, use whatever collation makes sense. Else, it is easier to just have it match between SharePoint and the system DBs.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.