How to Change SQL Server 2008 Collation

home
database
view story

1 Kicks

How to Change SQL Server 2008 Collation(onlydnn.com)

submitted by mynetnuke(522) 2 years, 9 months ago

Sometimes SQL Server collation and your database collation might be different. For example; Turkish hosting providers are using default Regional Settings while installing SQL Server 2005/20008. This is resulting master database collation to be set as Turkish_CI_AS. So far, no problem. You may experience outstanding issues while installing DotNetNuke using Turkish_CI_AS collation. At the very beginning after facing the collation problem i decided to use Latin1_General_CI_AS as server collation and results were very helpful.

add a comment |category: Database |Views: 52
Tweet