Changing the Default Database Encoding
To change the default database encoding (for example, to UTF-8), open the PHPMyAdmin interface.
- In the left-hand panel, select the required database.
- Go to the Operations tab.
- In the Collation section, select utf8_general_ci.
- Click Go.
We recommend choosing the collation according to your CMS requirements or the developer’s recommendations:
utf8_general_ci or utf8_unicode_ci — suitable for most CMSs.
utf8mb4_unicode_ci or utf8mb4_unicode_520_ci — recommended for new CMS installations on MySQL 5.6.
utf8mb4_0900_ai_ci — recommended for new CMS installations on MySQL 8.