12 thoughts on “SQL SERVER – Default Collation of SQL Server 2008”

“SQL Server offers the SQL_Latin1_General_CP1_CI_AS collation as the default collation for server installations”

This is not necessarily true

When I install on a UK machine using current disks or when I ask my hosting company to set up a new server the default is Latin1_General_CI_AS which although similar is not the same and will lead to conflicts so I have to do the REBUILDDATABASE thing to recreate the system databases.

Generally I don’t forget to change it in the setup but the hosting company use an image so they cannot create a default install with anything else (apparently – I think they’re just laze and won’t).

Good one Dave.
Hope someone covers the topic about the collation issues when installing SQL Server in different continents because these days due to high availability and load balancing everyone needs to understand what locale, Collation etc they should be in, for all the servers in respective countries or continents. Should they be the same then which one is the best etc etc… Cheers.

Hello sir,
While installing sql server 2008 on my windows 7 32-bit system, I get an error saying “The collation was not found error code 0x84b40000″.
When i select the collation tab, i see that the Database Engine field is blank and freezed. I cannot type anything there and as soon as i click on ‘Customize’ the installation ends there itself.
Please help.

Hello sir,
While installing sql server 2008 on my windows 7 32-bit system, I get an error saying “The collation was not found error code 0x84b40000″.
When i select the collation tab, i see that the Database Engine field is blank and freezed. I cannot type anything there and as soon as i click on ‘Customize’ the installation ends there itself.
Please help.

Community Initiatives

About Pinal Dave

Pinal Dave is a Pluralsight Developer Evangelist. He has authored 11 SQL Server database books, 17 Pluralsight courses and have written over 3200 articles on the database technology on his blog at a http://blog.sqlauthority.com. Along with 11+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). His past work experiences include Technology Evangelist at Microsoft and Sr. Consultant at SolidQ. Follow @pinaldave
Send Author Pinal Dave
an email at pinal@sqlauthority.com

Email Subscription

Enter your email address to subscribe to this blog and receive notifications of new posts by email.