A collation is a configuration setting that determines how the database engine should treat character data at the server, database, or column level. … In SQL Server, you can configure a character column with a Unicode data type (nchar, nvarchar, or ntext) or non-Unicode data type (char, varchar, or text).
Collation is a set of rules dictating how each group of characters within SQL Server is treated. A list of collations and their definitions can be found using the following query.
breaks up into interesting parts:
latin1makes the server treat strings using charset latin 1, basically ascii
CP1stands for Code Page 1252
CIcase insensitive comparisons so ‘ABC’ would equal ‘abc’
ASaccent sensitive, so ‘ü’ does not equal ‘u’