更改字符集
ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name;
So query will be:
ALTER TABLE etape_prospection CONVERT TO CHARACTER SET utf8;
alter table user modify column sex varchar(255) character set utf8;
alter table user DEFAULT CHARSET=utf8, modify column address varchar(255) character set utf8;