mysql - Change characters in sql file -


i have questions mysql , characters on .sql files.

i picked module accounting software (dolibarr if people know it) , problem .sql file.

this file looks :

enter image description here

i character enter image description here instead of getting french accent character "é" "è" "ô" etc ...

my question :

i assume it's character set problem. it's unicode , need utf-8 ? if it's truth, how can change ? because in file, there's not define :

default character set utf8 default collate utf8_general_ci;  

and don't know how .sql file called mysql database, it's maybe database problem ? :/

thank answers, , script if me :)

just open file in editor capable of reading encoding have in file , save file in desired encoding.


Comments

Popular posts from this blog

Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12:test (default-test) on project.Error occurred in starting fork -

windows - Debug iNetMgr.exe unhandle exception System.Management.Automation.CmdletInvocationException -

configurationsection - activeMq-5.13.3 setup configurations for wildfly 10.0.0 -