I've exported a WordPress MySQL database using phpmyadmin, but the special characters in the database text, like é, ç and so on, have been changed into ASCII strings. This happens even with certain "normal" characters, like the apostrophe. For instance, the word "Liebenberg's" now shows up as "Liebenbergâ¬"s".
I need to import the database into a new server, and want to convert from ASCII to UTF-8 for special characters during this process, so they show up as normal - but haven't seen a means for doing this.
I think a special script needs to be created to handle the job. I'm not sure how to compose the script for PHP, however, and can't find an ASCII-to-UTF-8 table for it to use.
Any help would be appreciated.
Start Free Trial
