View in #wordpress on Slack
@Joel_Yoder: I’ve run into a weird issue with our site. It appears that the wp_postmeta table does not support emojis, which means we can’t use them in our ACF-based page builder. The solution provided by the ACF community (https://support.advancedcustomfields.com/forums/topic/emoji-removed-from-custom-fields/) is to change the field collation type to
utf8mb4_general_ci, but I’m not sure what would be the recommended way to do that in the Pantheon environment that won’t fubar our site. Is there any way to do that on Pantheon?
ACF Support: Emoji removed from custom fields - ACF Support
@dashifen: I don’t have a solution, but it is nice to see a truck sheep in the wild
My guess is that you could do this via terminus with the WP CLI or via plugin, but the user needs to have ALTER TABLE permissions on the database, and I don’t know if Pantheon sets things up that way.
@JohnRichardsII: @joelyoder, This documentation on changing table types might help you do what @dashifen is recommending. It is a different use case but it shows examples of altering DB tables via a script.
@doug_pantheon: changing to this encoding will also not mess up your db, it’s compatible either direction