What are the implications of changing a table’s character set?

Background: Since UpdraftPlus 1.13.8 (autumn 2017), UpdraftPlus has been able to do extra checks upon your database prior to restoration for compatibility. In particular, it will look at the MySQL server that WordPress is running on, and make sure that it supports the...