Hi, I have, for me, a strange problem with charset. I move the databases - about 40 - to a new server.
Via c # and ExportToFile I have created sql files. MariaDB version 10.1 and MS Server 2008. If I open this file I can see the swedish characters.
Now I have tried the following in a MS Server 2016, MariaDB version
- Import via C # ImportFromFile. = swedish characters looks like rubbish
- A large file via Heidesql - open sql and run = swedish characters looks like rubbish
- The same large file via Heidesql, but only a small part - one table (ctrl+F9) = Swedish characters are ok.
I have tried to set DEFAULT CHARSET=utf8 but no difference. I also get an error with ENGINE=InnoDB.
I get nuts :) And I don't understand what I do wrong...
Can anyone who knows give me the right direction how to solve the problem?