Description of issue or problem I’m having:
I’m moving the OJS database from an “devil may care” configured MariaDB server to our new cluster, which is tuned and has specific standards we’re adhering to.
Here’s what’s changing:
The default engine in the new cluster is InnoDB.
The default character set is utf8mb4 (utf8 in mysql is not “true” utf8 utf8mb4 insures that each character has 4 bytes encoding.)
I exported the ojs database and imported it to our new cluster
I altered the engine type for each table and the character set and client character set for each table. Insuring that the ojs database was fully utf8mb4.
Now I see  characters. (example below)
To learn more about Open Journal Systems, visit http://pkp.sfu.ca/ojs/.
What I’m finding is that these characters are actually
vb.net - HTML encoding issues - "Â" character showing up instead of " " - Stack Overflow
What would be the best way to rectify this display error?
Thanks,
Erik