MySQL and Doubly-encoded to UTF-8 from CP1251, how to read data?

Question

MySQL

There is a string that is double encoded via in CP1251.
How to SELECT'om display the encoded string if the DB encoding is utf8_general_ci?

Answer 1

You probably won't be able to do this with database tools.

It will turn out.
select CONVERT(CAST(CONVERT(CONVERT(CAST(CONVERT('P ЎРµСЂРµРЅРµРІРµРЅСЊРєРС'Р в„–' USING cp1251) AS BINARY) USING utf8) USING cp1251) AS BINARY) USING utf8);
which is the same as
cat text | iconv -f utf8 -t cp1251 | iconv -f utf8 -t cp1251

Answer 2

We need to recode them back, obviously. You probably won't be able to do this with database tools.