Removing per column and table collation and charset
Converting columns:

ALTER TABLE table_name MODIFY col_name VARCHAR(100) CHARACTER SET utf8;


Converting tables:

ALTER TABLE table_name CONVERT TO CHARACTER SET utf8;