Collation is one of the most confusing features of SQL Server. BOL 2008 states that backward compatibility is the only reason to go with SQL collation. I thought previously it is just smart to stay with the default Microsoft offers unless there is a
real good reason to choose a different collation.
So is the default SQL_Latin1_General_CP1_CI_AS (Case Insensitive, Accent Sensitive) a good choice? (Assume the installation is brand new SQL Server 2008)
SQL Server offers the SQL_Latin1_General_CP1_CI_AS collation as the default collation for server installations.
For backward compatibility, the default English-language (US) collation is SQL_Latin1_General*.
Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM
View Complete Post