{"id":3457,"date":"2017-03-23T18:42:51","date_gmt":"2017-03-23T17:42:51","guid":{"rendered":"https:\/\/florianbrinkmann.com\/en\/?p=3457"},"modified":"2020-02-09T10:59:54","modified_gmt":"2020-02-09T09:59:54","slug":"switch-wordpress-from-utf8-to-utf8mb4-retrospectively","status":"publish","type":"post","link":"https:\/\/florianbrinkmann.com\/en\/switch-wordpress-from-utf8-to-utf8mb4-retrospectively-3457\/","title":{"rendered":"Switch WordPress from utf8 to utf8mb4 retrospectively"},"content":{"rendered":"\n
The WordPress 4.2 upgrade changed the database character set from Gary Pendergast lists the following requirements in his post \u00bbThe utf8mb4 Upgrade\u00ab<\/a> (quoted from his post):<\/p>\n\n\n\n Because my hosting provider Uberspace currently uses CentOS 6, which cannot reach the needed MySQL version, I did not get the update automatically with 4.2. After failing with saving an Emoji today, and getting the hint with If you now simply have a MySQL version which is high enough, you can likely change the character set via phpMyAdmin or similar tools (but I did not test that, because that would currently be no solution for me because of the above-named reason).<\/p>\n\n\n\n In any case, you need to change the tables to utf8<\/code> to
utf8mb4<\/code> (for example necessary for full emoji support) if a few requirements were met. This article shows you how to make the switch manually if you did not meet the requirements at the time of the WordPress 4.2 upgrade.<\/p>\n\n\n\n\n\n\n\n
Requirements for the
utf8mb4<\/code> update<\/h2>\n\n\n\n
utf8<\/code> character set.<\/li>
mysqlnd<\/code>, 5.0.9 or higher.<\/li><\/ul>\n\n\n\n
utf8mb4<\/code> from Bernhard Kau<\/a>, I searched for a solution. I found it in the post \u00bbutf8mb4 auf uberspace\u00ab on crusy.net \u2014 the solution for me is switching to MariaDB<\/a>.<\/p>\n\n\n\n
utf8mb4<\/code> after that \u2014 changing the database character set is not sufficient.<\/p>\n\n\n\n
Changing the tables to
utf8mb4<\/code><\/h2>\n\n\n\n