Yesterday I’ve upgraded one of my servers that is running on Ubuntu 18.04; since it’s reaching EOL it’s better to perform timely updates.
While upgrading the OS, why not upgrade MariaDB, right? So, I’ve upgraded it to 10.6.12 and this morning realized that one of the sites has been ruined with messed up characters.
Typically, stored data as latin1 is actually utf8… Since this is an old WordPress database, we had to convert the data into the actual format:
And, it did the trick!
I’ve read a bunch of non-sense solutions since found this one, hope it helps.
If you are setting up a new server, make sure to use utf8mb4 and thank me later 😉