Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

A customer has a SQL Server 2005 instance, collation SQL_Latin1_General_CP1_CI_AS, with 8 databases ... for a new application, we have been asked to install a SQL Server 2008 with collation SQL_Latin1_General_BIN.

In order to maintain a single database server, and then also by addressing the previous db migration to the new version, which instance collation should be adopted?

Thanks a lot

Bye, Francesco

share|improve this question

migrated from stackoverflow.com Feb 22 '12 at 16:13

This question came from our site for professional and enthusiast programmers.

1 Answer 1

The default collation is based on the Windows system locale of your server. SQL_Latin1_General_CP1_CI_AS is usually the default collation for computers based in the North American locale. Collation can be changed if you have a reason for it, like: sorting order, case sensitivity, accent sensitivity, non-English characters, width.

Collation for a DB can be set at the time of the creation of the DB, so you can have a server that has DBs with different collations. The Alter database command can be used to change the collation of all newly created objects in the DB. I have used the default SQL_Latin1_General_CP1_CI_AS all the time and have not had any issues, but then I do more DB administration that development.

share|improve this answer
    
The default collation is based on your regional settings. See dba.stackexchange.com/a/7212/630 –  gbn Feb 23 '12 at 7:49
    
That is very good info. Thanks @gbn. It is hard to come by the experience of installing in different regions (countries). –  StanleyJohns Feb 23 '12 at 18:16
    
I only found this out by testing for this answer... –  gbn Feb 23 '12 at 18:17

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.