CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER SCHEMA database DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
ALTER TABLE table_name CHARACTER SET utf8 COLLATE utf8_unicode_ci;

ALTER TABLE mytable CONVERTTO CHARACTER SET utf8;

show table status;