When I export a DB everything looks as expected. I can open up the file in a text editor and everything is as expected. When I import or open the file in HeidiSQL special characters get converted to junk. For example an mdash (—) gets converted to
â€”. Whether I import the SQL file or run it, the special characters get ruined. I just uploaded the file to the server and used a
mysql command to import the DB and everything imported just fine. No characters were changed.
The export is from a Linux server with MySQL. I am saving to a Windows machine. This happen on Version 11.3 (22.214.171.12495) and the latest version 11.3 (126.96.36.19957).
Is this a bug or is there something I should be aware of?