Collation names, at least in SQL Server, are structured in that they contain various pieces of information detailing some of the properties of the collation. The collation name of
SQL_Latin1_General_CP1_CI_AScan be broken down as follows:
SQL_This indicates that the collation is a SQL Server collation, while names without this prefix indicate Windows collations
Latin1_GeneralThis is the culture (a.k.a. locale) used for the sorting and comparison rules
CP1This is the 8-bit [C]ode [P]age
CIThis indicates [C]ase- [S]ensitive or [I]nsensitive
ASThis indicates [A]ccent- [S]ensitive or [I]nsensitive
Ok, but there’s no code page “1”. So, what’s going on there?
Read on to learn the answer behind this mystery.