Collation refers to the pre-defined rules to sort and compare data, and it also defines bit patterns that represent characters in a database.
BrindhaPrathaban Answered question
A collation specifies the bit patterns that represent each character in a dataset. Collations also determine the rules that sort and compare data. SQL Server supports storing objects that have different collations in a single database
BrindhaPrathaban Answered question
A collation defines the bit patterns that each character in a dataset uses. Collations also define the rules for sorting and comparing data. SQL Server allows you to store items with different collations in the same database.
Vishalini.R Answered question