In the database dump of the table in two encodings. How to lead to one?

Question

MySQL

There is a database dump from cms typo3 . It contains part of the data in utf-8, part in cp-1251.
Example:
UTF-8: (175, 'Tula region', 2,
Win-1251: (46271846, 'Положение о Контрольно - ревизионнол
How come it happened ? initially I don't know, but I need to bring it all to a single view.Now part of the site is displayed normally, part is not normal.I change the encoding in the browser and what was displayed normally becomes abnormal and vice
versa.How to solve this problem?

Answer 1

Option 1:
Through phpMyAdmin eg Tables - Table Analysis. Get a list of curved tables.
change the encoding to UTF-8 (and at the same time make UTF-8 the default in the CMS) for specific tables.
option 2:
Dumper to help you: Sypex Dumper
make a backup with define('CHARSET', 'auto')
expand the backup with define('RESTORE_CHARSET', 'forced->utf8')
should work.