Title: Mixed Database character set
Last modified: October 4, 2023

---

# Mixed Database character set

 *  [greencode](https://wordpress.org/support/users/greencode/)
 * (@greencode)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/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.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 2 participants
 * Last reply from: [greencode](https://wordpress.org/support/users/greencode/)
 * Last activity: [2 years, 8 months ago](https://wordpress.org/support/topic/mixed-database-character-set/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics