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.

The default collation of our new server is SQL_Latin1_General_CP1_CI_AS. However the collation of the other databases which are used as the source to migrate data into the target databases on this server are Latin1_General_CI_AS.

To avoid getting the error while we load data from database 1 (collation:Latin1_General_CI_AS) to database 2 (collation:SQL_Latin1_General_CP1_CI_AS), I changed the collation of database 2 (the target database) to Latin1_General_CI_AS.

However I'm wondering if it might any side-affect? What is the reason that the server default collation is SQL_Latin1_General_CP1_CI_AS? Is it any better than other collation, in terms of performance, etc?

Thanks for your help.

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

I worked out this issue and share it here, in case someone needs it in future.

The default collation setting is determined by the server locale. For most English speaking countries is it : Latin1_General_CI_AS

If the server locale setting has been left as default which is English (United States), the collation at time of MS SQL Management Studio would be set to SQL_Latin1_General_CP1_CI_AS.

enter image description here You can check the collation for each local in the following url:

http://msdn.microsoft.com/en-us/library/ms143508.aspx

share|improve this answer
    
I ran through the setup installer for SQL 2008 r2 Express and Standard edition and the default value for collation is certainly "SQL_Latin1_General_CP1_CI_AS" . If you want "SQL_General_CI_AS" , you would have to change the default config value during setup. –  djangofan Aug 12 '13 at 18:52
add comment

Your Answer

 
discard

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

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