Backed up my database, but when restoring the site can barely be read. It's written in a foreign language. I tracked the problem down to differences between the database (accessed though phpmyadmin.powweb.com) and the back up file.
Database on line says: " contradicciÃƒÂ³ "
Backup file reads: " contradicciÃƒÆ’Ã‚Â³ "
Or " perÃƒÂ² " vs. " perÃƒÆ’Ã‚Â² "
When restoring the website reads " perÃƒÂ² "
I'm told that I need to convert the backup file to a different format. Like utf-8, but I don't know how to do it, nor I have the appropriate tools. What's more, I don't know why I need to convert the file. Wouldn't it be better if the file was ok in the first place, or even the database (don't understand why it's stored that way).
Can you help me with this?