A collation is a set of rules that determine how data is sorted and compared for comparing characters in a character set.

A collation is a set of rules that determine how data is sorted and compared for comparing characters in a character set.

Here some kind of collation rules:

  • Case sensitivity
  • Accent sensitivity
  • Kana Sensitivity
  • Width sensitivity

Depending on the RDBMS we can have all or a subset of collation