MySQL - Change Collation and Character Set

copy
show table status from epals_journalismcenter where name = 'contents'

ALTER DATABASE epals_journalismcenter CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE contents CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE contents CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci