replied on 01-07-2012 11:04
Collation refers to a set of rules that determine how data is sorted and compared.
Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types and character width.
Case sensitivity - If A and a, B and b, etc. are treated in the same way then it is case-insensitive.
Accent sensitivity - If a and á, o and ó are treated in the same way, then it is accent-insensitive.
Width sensitivity - When a single-byte character (half-width) and the same character when represented as a double-byte character (full-width) are treated differently then it is width sensitive.