Set WordPress app database collation to uft8_general_ci instead of latin1_swedish_ci
When installing a new WP app, the database collation is set to latin1swedishci. It should be utf8generalci. Just change the way the app installer works, to set it to the correct setting when installing a new WP app. Also consider adding the collation to the new WP install's wp-config.php file to help keep all tables using the correct collation: https://codex.wordpress.org/Editing_wp-config.php#Database_collation.
We've started to see some issues on some sites due to mixed table collation. This would help prevent issues by keeping everything on compatible variations of utf8.
7
votes
