Change the collation for a table

query to change the collation of a table.

alter table collate utf8_unicode_ci

To change the default character set and collation of a table including those of existing columns (note the convert to clause):

alter table convert to character set utf8 collate utf8_unicode_ci;