How to Change the Character Set Issue with WordPress Site’s ?

How to Change the Character Set Issue with WordPress Site’s ?

45
0
SHARE
Linux Reseller Hosting

wordpress-logo

How to change the Character Set Issue with WordPress Site’s ?

You should change wordpress character set by using following command.

mysql –database=jargalan_wrdp1 -B -N -e “SHOW TABLES” | awk ‘{print “ALTER TABLE”, $1, “CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;”}’ |
mysql –database=jargalan_wrdp1 &

Here make sure to replace your database name with : username_drpl1

Then restart the mysql service couple of times to make it work !

Windows Shared Hosting

Our Partner

partner-cloudflare
partner-cloudlinux
partner-cpanel-whm
partner-Paralleles-plesk-panel
partner-sitelock
partners-OpenVZ
R1Soft
partners-RV-Globalsoft
partners-Softaculous-auto-installer
partners-solusvm
partners-whmcs
services-cpanel
services-MySQL
services-Perl
services-swsoft-plesk
support-sevices-php