MySQL collation names follow these rules:
A name ending in _ci indicates a
case-insensitive collation.
A name ending in _cs indicates a
case-sensitive collation.
A name ending in _bin indicates a
binary collation. Character comparisons are based on
character binary code values.