What is the best collation to use for MySQL?

Last updated 2 years, 4 months ago | 307 views 75     5

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.