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?
##How to deal with Chinese garbled wordpressRecord 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:
rrreeeDone!
Recommended study: "
WordPress TutorialThe 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!
Hot AI Tools
Undress AI Tool
Undress images for free
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
How to adjust the wordpress article list
Apr 20, 2025 am 10:48 AM
There are four ways to adjust the WordPress article list: use theme options, use plugins (such as Post Types Order, WP Post List, Boxy Stuff), use code (add settings in the functions.php file), or modify the WordPress database directly.
10 latest tools for web developers
May 07, 2025 pm 04:48 PM
Web development design is a promising career field. However, this industry also faces many challenges. As more businesses and brands turn to the online marketplace, web developers have the opportunity to demonstrate their skills and succeed in their careers. However, as demand for web development continues to grow, the number of developers is also increasing, resulting in increasingly fierce competition. But it’s exciting that if you have the talent and will, you can always find new ways to create unique designs and ideas. As a web developer, you may need to keep looking for new tools and resources. These new tools and resources not only make your job more convenient, but also improve the quality of your work, thus helping you win more business and customers. The trends of web development are constantly changing.
How to import the source code of wordpress
Apr 20, 2025 am 11:24 AM
Importing WordPress source code requires the following steps: Create a sub-theme for theme modification. Import the source code and overwrite the files in the sub-topic. Activate the sub-theme to make it effective. Test the changes to make sure everything works.
How to build a website for wordpress host
Apr 20, 2025 am 11:12 AM
To build a website using WordPress hosting, you need to: select a reliable hosting provider. Buy a domain name. Set up a WordPress hosting account. Select a topic. Add pages and articles. Install the plug-in. Customize your website. Publish your website.
How to add your WordPress site in Yandex Webmaster Tools
May 12, 2025 pm 09:06 PM
Do you want to connect your website to Yandex Webmaster Tools? Webmaster tools such as Google Search Console, Bing and Yandex can help you optimize your website, monitor traffic, manage robots.txt, check for website errors, and more. In this article, we will share how to add your WordPress website to the Yandex Webmaster Tool to monitor your search engine traffic. What is Yandex? Yandex is a popular search engine based in Russia, similar to Google and Bing. You can excel in Yandex
How to set, get and delete WordPress cookies (like a professional)
May 12, 2025 pm 08:57 PM
Do you want to know how to use cookies on your WordPress website? Cookies are useful tools for storing temporary information in users’ browsers. You can use this information to enhance the user experience through personalization and behavioral targeting. In this ultimate guide, we will show you how to set, get, and delete WordPresscookies like a professional. Note: This is an advanced tutorial. It requires you to be proficient in HTML, CSS, WordPress websites and PHP. What are cookies? Cookies are created and stored when users visit websites.
How to register a wordpress account
Apr 20, 2025 am 11:45 AM
To create an account on WordPress, simply visit its website, select the registration option, fill in the registration form, and verify your email address. Other ways to register include using a Google account or Apple ID. The benefits of signing up include creating a website, gaining features, joining the community, and gaining support.
How to fix HTTP image upload errors in WordPress (simple)
May 12, 2025 pm 09:03 PM
Do you need to fix HTTP image upload errors in WordPress? This error can be particularly frustrating when you create content in WordPress. This usually happens when you upload images or other files to your CMS using the built-in WordPress media library. In this article, we will show you how to easily fix HTTP image upload errors in WordPress. What is the reason for HTTP errors during WordPress media uploading? When you try to upload files to Wo using WordPress media uploader
