18 January 2011

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 :
  1. Export the db to an sql script
  2. Open file in notepad++
  3. In menu > encoding, select convert to ANSI
  4. In menu > encoding, select encode to UTF8
  5. Save the file
  6. Import the converted sql file in mysql
Post a Comment