MYSQL How to transcode text from cp1251 to utf 8?

Question

MySQL

Hello! There are sql tables of cities, regions and countries and values ​​in them. Values ​​are encoded cp1251 I would like to convert them to utf8 How to do it quickly?

INSERT INTO `city` VALUES (10664, 10648, 10663, 'Èéâàñêèëà');

Answer 1

On Linux it's easy:
If the data is already in the DBMS, then you need to:
1. make a backup copy to a file,
2. convert the file with the command above,
3. configure the server for a new encoding,
4. Restore from the converted file.

Answer 2

Open in Notepad++ and give the command Encodings->Convert to UTF-8 without BOM

Answer 3

I do not know what is available on the poppy. Any transcoder from one to another. Linux has enconv, iconv.