SQL to select and change the collation from one to another. (utf8, for example.)

change_all_tables_collation.sql

# ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
# ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

SELECT CONCAT("ALTER TABLE ",TABLE_SCHEMA,".",TABLE_NAME," CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;") AS alter_sql
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'cms';