How to change all encoding in mysqul phpmyadmin?

Question

MySQL

enter sql query

SELECT CONCAT('ALTER TABLE `', t.`TABLE_SCHEMA`, '`.`', t.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') as sqlcode
FROM `information_schema`.`TABLES` t
WHERE 1
AND t.`TABLE_SCHEMA` = 'rielt2'
ORDER BY 1

Encoding does not change, throws an error

spoiler

This table does not contain a unique column. Changing the grid, ticking, editing, copying and deleting is not available.

Changed encoding manually.

But internally it doesn't change
. How can I change the encoding recursively?
In MODX there are only kryakozyabry

Answer 1

1. The request generated great commands for you to change the encoding.
RUN THEM.
2. Maybe it makes sense to explicitly indicate the connection encoding at the stage of connecting to the database? In the database connection code right after connect.
set names utf8;

Answer 2

You have confused encoding and db mapping.
In modern versions of MySQL, the encoding is always UTF-8.