Using SQL Server Collations - MSDN - Microsoft

SQL Server 2008 collation settings depend on the type of installation. Typically ... SQL Server 2008 R2 Books Online ... order, case-insensitive, for use with 1252 character set SQL Server 2008 collation.

msdn.microsoft.com