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