[bug] SQL file load shows shifted first line

Hi,

Using HeidiSQL 9.4.0.5130 I saw something I did not experience before. I loaded an SQL query from file. The contents is shown with the first line starting with a space - which is not in the file. I can't remove that space, when I do it stays where it is and the first real query character is removed. When I go from left to right then 1 position before an opening bracket(so 1 pos too early) highlighting occurs but both highlighted brackets are shown shifted one position to the left. So it seems the representation of the line internally and externally are out of sync. The query does not run, it throws an SQL error. Whatever I try I seem not to be able to get rid of the mysterious first character, other than cutting the query text, selecting everything else and deleting this.

Frank

Using HeidiSQL 9.4.0.5130

Failed to add that 5133 did not solve this issue.

Frank

You either have a non-printable Unicode character (any hex editor can tell you which one) or you've chosen an incorrect encoding in the Encoding drop-down of the file chooser:

Sorry, the forum software doesn't seem to like my picture:

https://i.imgur.com/r0KcpvS.png

Grmmmmfff!

https://i.imgur.com/r0KcpvS.png

@Anse, is there something broken?

OK. Got that (I followed the imgur url myself ;-) ). You are right: with ANSI encoding I see special characters at the beginning of the file. I tried a text viewer first (really I did), but it did miss those... :-(. My bad, please consider this bug not posted. I'll be under a rock somewhere for the next couple of hours...:-)

frank

@kalvaro: sorry, your url trapped into a \br\d+ regular expression for creating revision links :)