What to do if WordPress is garbled

Solution to wordpress garbled characters: 1. Modify "define('DB_CHARSET', 'utf8′);" in the "wp-config.php" file to "define('DB_CHARSET', ");" ;2. Set the encoding of the new database to "latin1_swedish_ci"; 3. Import the backup database file in uft8 format.

The operating environment of this tutorial. ：Windows10 system, WordPress5.4.2, Dell G3 computer.

##What to do if wordpress is garbled?

Record this, I hope it will be useful to others!

Due to business needs, the company needs to build a website, mainly for content display and content management, so I chose the WordPress system as the website.

EnvironmentRed Hat Enterprise Linux 5 RPM (x86)

1, install MySQL, install through source code

#./configure --prefix=/usr/local/mysql --with-charset=gb2312 |注:配置Mysql安装路径并且支持中文

2, install Apache server, also install through source package

3 , install PHP, same as above

4, install WordPress (Chinese version)

After the installation was completed, I published an article and found that it was garbled. Then the problem came out! I found several solutions from the Internet

For example, the ultimate solution to the "uncommon sense" wordpress garbled problem,

I really feel that using the word "ultimate" is not an exaggeration, because this is what I After seeking medical advice for more than ten days, I finally bought a prescription for 200 yuan. It is easy to operate and does not require complicated knowledge. Thanks to the seller G who solved the problem! The method was successfully tested in mysql5.0 and may also be applicable to 4.1. The steps are as follows:

Rewrite "define('DB_CHARSET', 'utf8′);" in the wp-config.php file to "define('DB_CHARSET', ");" ( Note that double quotes are not included), that is, this code does not specify any character set;

• Set the encoding of the new database to latin1_swedish_ci (set in "Operation");

• Import the backed up database file in uft8 format.

• It’s over, let’s make it simple

It didn’t work even after setting it up. Later I found out how to set the default character set of mysql to UTF-8 from the open source sky,

How to set the default character set of mysql to UTF-8

We often talk about Joomla! supporting Chinese character sets. It is best for the database to use UTF-8 character sets. Now mysql 4.0 and above support UTF-8 character sets. , so how to set the default character set to utf-8?

Under Linux, add:

# default charaset utf8
character-set-server=utf8
collation-server=utf8_general_ci
default-character-set=utf8

to the mysql configuration file, my.cnf:

# vi /etc/my.cnf

Then restart mysql, log in to the mysql shell, and use show variables; to see if your default character set is UTF-8, when creating databases and tables, the default character set is UTF-8, which saves a lot of trouble.

So I did as follows:

# default charaset utf8
character-set-server=utf8
collation-server=utf8_general_ci
default-character-set=utf8

Then I added

# vi wp-config.php

after the file, but it was still garbled.

After thinking about it, it turned out to be wp-config An encoding problem in the .php file caused

define('DB_CHARSET', 'utf8');

to be found and modified as follows:

Done!

Recommended study: "

"

The above is the detailed content of What to do if WordPress is garbled. For more information, please follow other related articles on the PHP Chinese website!