MySQL/MariaDB Character Problems: latin1_ to utf8_

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.