Collations define rules that sort and compare data. When you create your database, choose your collation carefully based ...

Collations define rules that sort and compare data. When you create your database, choose your collation carefully based on your application needs. Note that you cannot change the collation after the database has been created. The default collation is SQL_Latin1_General_CP1_CI_AS:  Latin dictionary, code page 1 (CP1), case-insensitive (CI), and accent-sensitive (AS).