I have a MySQL table that has a number of columns with the latin1 character set. Because of driver issues, the columns actually contain utf8 data. I want to leave the data as-is but change the column character set to UTF8.
Every solution I've examined does two alter table commands, changing the column to binary, then back to the previous type with the new character set.
There are multiple columns on multiple tables in multiple databases, so this approach would be pretty slow.
Is there a better way to get this done?