MySQL - Change Collation and Character Set

4/5/2013 12:45:18 AM
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