Collations define rules that sort and compare data. Make a thoughtful choice of collation, based on application needs, at ...

Collations define rules that sort and compare data. Make a thoughtful choice of collation, based on application needs, at the time you create your database. Note that a collation cannot be changed after database creation. The default collation is SQL_Latin1_General_CP1_CI_AS:  Latin dictionary, code page 1 (CP1), case-insensitive (CI), and accent-sensitive (AS).