Just putting it here since the next time it’s needed I won’t remember: ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; got it from here