how Collation works in sql code example

Example: collation in sql

Collation is defined as a set of rules
that determine how data can be sorted as
well as compared. Character data is sorted
using the rules that define the correct
character sequence along with options for 
specifying case-sensitivity, character width etc.