What is Collation setting in SQL Server?
- Collation is some set of rules that determines how the data is stored and compared.
- Collation specifies the communication language in SQL Server.
- Collation setting is varied from county to country based on the language.
- The default collation setting in US language. i.e.
- ” SQL_Latin1_General_CP1_CI_AS”