2019-11-11, 08:20 AM
I have a relatively new Forum, with a few hundred threads. I just realized that my hosting provider has a default MySQL character set as latin1. When I take a backup and restore to UTF8, pages are showing incorrect characters. For example, the page https://www.devopsrun.com/t-bash-tree-co...7-centos-8 has
I used the below method to convert the DB character set:
├── anaconda-ks.cfg
and after UTF8 conversion it shows like,??? anaconda-ks.cfg
I have spent a few hours to find a solution, nothing succeeded so far. I appreciate your suggestions to solve this issue.I used the below method to convert the DB character set:
iconv -f LATIN1 -t UTF-8 < db.sql > db-utf8.sql
Following all steps given here: http://bdunagan.com/2011/09/29/convertin...1-to-utf8/