
Mostly we use:
- utf8_general_ci
- utf8_unicode_ci
utf8_general_ci is use for fast sorting but it is less accurate whereas utf8_unicode_ci is used for better accuracy but little slow as compare to utf8_general_ci.
We can also use other collation based on specific languages like utf8_swedish_ci.