A user who is sufficiently privileged can also define an appropriate collation.
If a custom collation is required, and CHARSET_COLL collation does not produce the desired result, then you can modify the MULTINATIONAL collation. For information, see MULTINATIONAL Collation for Extended Site-Defined Character Sets.