Encoding in the database table

Question

MySQL

Good afternoon. There is a table in the database. For some reason, it received information with different encodings. Part in cp1251 and part in utf-8. Now you need to make a backup. Tried already through phpmyadmin and through sypex dumper with different encoding. At the output, I get a part in a curved encoding of the form

143,18,\N,\N,\N,\N,\N,\N,\N,\N,\N,\N,\N,\N,\N,\N,'Как пойти в поход на лыжах?','\n
and a part of a normal one.

What can be done to bring it to one view with a normal encoding?

Answer 1

Please do "SHOW CREATE TABLE <table_name>;" and throw off the conclusion in addition to the question, so it will be clearer.

Answer 2

Perhaps I would try to do the conversion with a script, for example, in PHP. There are not so many records, so the selection of rows in the table for recoding can be done manually

Answer 3

"Part" are different records in one table, or in one UTF8 table, in another cp1251?