mysqlunicodeutf-8utf8-decode

Change characters in sql file


I have some questions about MySQL and characters on .sql files.

I picked up a module for an accounting software (Dolibarr if some people know it) and I get a problem with an .sql file.

This file looks like :

enter image description here

I get this character enter image description here instead of getting french accent character like "é" "è" "ô" etc ...

My question is :

I assume that it's a character set problem. It's unicode and I need utf-8 ? If it's the truth, how I can change that ? Because in this file, there's not define something like :

DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci; 

And I don't know how this .sql file is called by the MySQL database, so it's maybe a database problem ? :/

Thank you to your answers, and your script if you could help me :)


Solution

  • Just open your file in an any editor capable of Reading the encoding you have in your file and then save the file in the desired encoding.