Title: mySQL Collation
Last modified: August 11, 2021

---

# mySQL Collation

 *  [alvinyong](https://wordpress.org/support/users/alvinyong/)
 * (@alvinyong)
 * [5 years ago](https://wordpress.org/support/topic/mysql-collation-3/)
 * What is the best mySQL collation version for the latest WordPress 5.8?
 * utf8mb4_unicode_ci
    utf8mb4_unicode_520_ci utf8_general_ci
 * I am not sure which version to create
    -  This topic was modified 5 years ago by [Jan Dembowski](https://wordpress.org/support/users/jdembowski/).

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [corusx](https://wordpress.org/support/users/corusx/)
 * (@corusx)
 * [5 years ago](https://wordpress.org/support/topic/mysql-collation-3/#post-14753400)
 * general is outdated use `utf8mb4_unicode_520_ci` if available otherwise unicode
   is fine
 *  [Dion](https://wordpress.org/support/users/diondesigns/)
 * (@diondesigns)
 * [5 years ago](https://wordpress.org/support/topic/mysql-collation-3/#post-14753897)
 * You should use `utf8_unicode_ci` for the database collation and `utf8` for the
   database character set. The `utf8mb4` character set and collations are inefficient
   compared to `utf8`, and applications that store raw emojis (such as WordPress)
   will manually set the `utf8mb4` character set and collation on all the tables/
   columns it creates.
 * (FWIW, if WordPress required the PHP `mbstring` extension, it could use `mb_convert_encoding()`
   to store emojis as HTML entities, which eliminates the need for the `utf8mb4`
   character set and collations.)

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘mySQL Collation’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 3 participants
 * Last reply from: [Dion](https://wordpress.org/support/users/diondesigns/)
 * Last activity: [5 years ago](https://wordpress.org/support/topic/mysql-collation-3/#post-14753897)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics