How to change the default charset of a MySQL table?
If you want to change the table default character set and all character columns to a new character set, use a statement like this: ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name; So query will be: ALTER TABLE etape_prospection CONVERT TO CHARACTER SET utf8;