• 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.