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
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
This could not posblsiy have been more helpful!