Mixed Database character set
-
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.