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 :
I get this character 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 :)
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.