What is the best collation to use for MySQL?

Last updated 2 years, 10 months ago | 514 views 75     5

Tags:- MySQL

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.