How to convert database from latin1 to utf-8?

Question

MySQL

I have a large database and latin1 framing is based on it. I tried many ways
ALTER TABLE `content`.`part1` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
iconv('utf-8', 'latin1', $row['price']);
mb_convert_encoding($str, 'latin1','utf-8');
but can't convert properly

Answer 1

Dump in one encoding, change the encoding in the dump file and import back into mysql. It is only desirable to another database so that the data is not lost if something happens.