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