Charset Alteration Problem

Hi everyone,

I created a website and wordpress and exported my database from phpmyadmin. Then when I tried to import the database to my hosting providers phpmyadmin, I had the unknown charset error. My databases charset is utf8mb4 but my hosting provider requires it to be utf8, due to older version.

Then I changed the charset of the tables in my database by executing the command of “ALTER TABLE X CONVERT TO CHARACTER SET X” command. It worked, except two tables: wp_icl_translate_job and wp_term_relationships. How can I change the charsets of these two?

Thanks in advance.