After restoring database with new dump, I got some weird characters being displayed on website. For example:
"Instruções" Replaced the Portuguese word "Instruções"
"P O R T U G U Ã? S" Replaced the Portuguese word "P O R T U G U Ê S"
"E S P A Ñ O L" rather than "E S P A ?' O L"
*This happened to all Portuguese and Spanish language words that use characters that are not used in English such as ñ é ç ê ã and many others.
I have the possibility to EXPORT the database again from my old host and then restore it again to my new server.
[B][COLOR="Red"]My database (exported with the settings below) has several lines that read: ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 [/COLOR][/B]
[U][B]CURRENT EXPORT SETTINGS[/B][/U]
[IMG][login to view URL][/IMG]
[U][B]CURRENT IMPORT SETTINGS[/B][/U]
[IMG][login to view URL][/IMG]
## Deliverables
Coder must:
1. Find the cause of the problem and fix it completely so that all characters on website display correctly.
2. Restore database or give instructions on how I can restore it, whichever I prefer. (MySQL database is less than 20 MB).
## Platform
Linux server
MySQL
PhpMyAdmin