What is the best collation to use for MySQL?

Last updated 4 years, 8 months ago | 1028 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.