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