quickly fix misencoded characters in mysql DB
If some accentuated characters of your database have been misencoded in the db, for example the french character é appears as é you can follow these steps to correct the accentuation :
- Export the db to an sql script
- Open file in notepad++
- In menu > encoding, select convert to ANSI
- In menu > encoding, select encode to UTF8
- Save the file
- Import the converted sql file in mysql
Comments