1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Error: strange characters when importing a MySQL dump
If you recover one of these dumps and you import it into your database, all the accents may be replaced by strange characters (some "?" for example).
Please note that the MySQL database backups are done in UTF8 format. Accented characters are then encoded in two bytes. Importing these backups does not pose a problem on our servers; however it is up to you to adapt your house configuration for importing databases in UTF8 locally on your PC.
For example, you can make a utf8 -> latin1 conversion of the SQL file before import.
Otherwise, when the database is imported, you will just need to specify that your input file is in iso-latin1 format (import section, "character sets of file") and import will then be carried out correctly.
When special characters are converted to '?', it is likely that the file you're importing is in a non-UTF-8 format and the software is configured to import UTF-8 files. Linux can do a conversion to UTF-8 using the 'iconv' command.
Please read this FAQ as well (click here).
Link to this FAQ: