How to correctly change the database encoding?

Question

PHP

There are 10,000 news items in the database, cp-1251 encoding. Is it possible and how to change it to utf-8 correctly? Or just replace the encoding in the tables with the required one? Thank you.

Answer 1

ALTER DATABASE base CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE table CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;