• I’ve been having issues with a plugin whereby when a user adds an emoji into a custom field (created via the plugin) in a WooCommerce product, that field then doesn’t show on the order email or order in the backend.

    What I noticed, in the DB, is that the charsets seemed to be mixed for different tables (utf8mb4_unicode_520_ci, latin1_swedish_ci, utf8mb4_unicode_ci, utf8mb3_general_ci)

    I’ve tested on a Staging site and changed all tables to utf8mb4_unicode_ci and that appears to have fixed the issue but I’m a little nervous about doing this on the live site in case it messes something up.

    Is it safe to change all of the tables? The site is in English BTW.

The topic ‘Mixed Database character set’ is closed to new replies.