How to correctly change the encoding of the Wordpress database?

Question

MySQL

Good afternoon, I ran into a problem, I was transferred some separate tables from one database to another and it turned out that part of the database was encoded in utf8, and part in the newer utf8mb4. The dream needs the entire database to be in utf8, because the server does not support the newer encoding. I just can’t figure out how to do everything right, I open the Notepad ++ dump, click "convert to UTF-8 without BOM". I save. But when I open the file it still shows "ANSI".
Just replacing all utf8mb4 with utf8 in the dump did not help..

Answer 1

You probably don't have direct access to MySQL, so use PHPMyAdmin or HeidiSQL. Command syntax:

ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;