Skip to content

Instantly share code, notes, and snippets.

@ideadude
Created October 21, 2022 13:50
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ideadude/9826f74b44f607127c67ea66ddc190ab to your computer and use it in GitHub Desktop.
Save ideadude/9826f74b44f607127c67ea66ddc190ab to your computer and use it in GitHub Desktop.
Update some PMPro DB tables to use UTF8 character sets.
# PMPro doesn't set the character set when creating its tables.
# So on install PMPro will use the default character set for your DB.
# In some cases this might be something like latin1, which will not
# work with special characters for non-latin languages, e.g. Hebrew.
# To fix this, you can update the character set on these tables using MySQL.
#
# IMPORTANT: Back up your DB (at least these tables) before running any queries.
ALTER TABLE wp_pmpro_membership_levels CONVERT TO CHARACTER SET utf8;
ALTER TABLE wp_pmpro_membership_levelmeta CONVERT TO CHARACTER SET utf8;
ALTER TABLE wp_pmpro_membership_ordermeta CONVERT TO CHARACTER SET utf8;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment