A
A
Alexander Mamishev2015-09-25 12:29:19
MySQL
Alexander Mamishev, 2015-09-25 12:29:19

How to make WordPress become UTF8 and not UTF8MB4?

Instead of a capital letter AND, this thing is displayed:
�?
As I understand it, this is due to the fact that by default WordPress is installed with UTF8MB4 encoding.
But after migrating the site, MySQL version became 5.1.73, it doesn't support UTF8MB4. How can you tell WordPress that the server no longer supports UTF8MB4. I corrected the database and tables, and again he makes new publications in this unsupported encoding ... an infection.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
Maxim E, 2015-09-25
@creativeworm

in wp-config.php there should be a line:
specify like this:
define('DB_CHARSET', 'utf8');

A
Alex, 2015-09-25
@mr_ko

I recently ran into a similar problem during the transfer.
I installed a config on a dumb hosting as Maxim Creative
writes . I made a backup of the database to a file. In the file, I replaced all utf8mb4 with utf8.
After that, I uploaded the database to a new hosting.
Everything worked fine. Even WordPress was already updated, there were no problems.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question