I wanted to write Japanese in one of my wordpress blogs. The issue was that the encoding was in latin1. Here are the steps I used below. Keep in mind that this is a potentially dangerous modification where you could easily lose your data. Be careful and if you try this, you do it at your own risk! Make a complete backup of your site by whatever methods you normally use. Also make a backup of your wordpress site’s database. Login into CPanel and select phpMyAdmin. Click the SQL tab around the top of the page on the right panel. This is where you can execute SQL code. ALTER DATABASE dbname DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; (where dbname is the name of your database) That line fixes the existing database by changing the default encoding. In my case I had a latin1 variant. That step above is to avoid completely dropping and re-creating the database. Login into CPanel again and download a copy of the database using the backup wizard. This consists of a tar.gz (zip...
Computers, programming, software development, AI, design, and more!