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 !
