German Umlaut – with right encoding

Hi Ansgar, hi everyone,

first, I still love HeidiSQL ... still here, still using, still progress! Love it!

Second, a few years ago I had this thread: https://www.heidisql.com/forum.php?t=37547#p37552

So, it seems - with the actual version - there is a similar problem, and these are the made steps:

• CTRL - O
• selecting UTF-8
• selecting the exported file (made with your current version; INSERTS are correct [no fragments]!)
• loads into tab (small enough; no direct run dialog)
• pressing F9 or icon
• runs smoothly without errors

After import, I have fragments ... like from ISO, ASCII.

Another try (new export), added COMMENTS, removed DEFINER, non-zipped (single file) ... same result!

Export contains drop, create ...!

Something is wrong ... I guess ... :) (and this is not drag'n'drop like five years ago).

Any suggestions?

Many thanks and best regards

And there are now import fragments (after several further tries) ...

That garbled text in the log panel is issue #2198 - please go there and perhaps even post a script which can be used to reproduce the issue. I could not yet reproduce it.

Please note this is just the log output. Nothing which affects the server sided data or something other important.

I solved my problem ... and it's not your fault! rolling eyes

I was going to answer, prepare a file for reproduction and mentioned the background: a cms. Well, the cms uses caching, that is not updated (e. g. new stuff in db) if not logged in. So, long story short: after login into cms, deleting cache, the fragments are gone. oh boy ... a real layer-8 problem!

My attachment: It appears after a main window resizing. I tried this now several times to reproduce, but, unhappily, it failed until now. Maybe there is a magic width I hit with the resizing for the log or sth. like that. I resized in the right bottom corner by mouse.