Posts

Showing posts with the label convert

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