Table Collation

In my previous post, I explained on how to Convert MyISAM to InnoDB. This time I’ll show you on how to change the collation of MySQL database tables. BTW, collation controls the way string values are sorted. This code is useful if the table collation varied from each other. Example one table has utf8_general_ci collation, while the other has utf8_unicode_ci. It’s a best practice if there is