Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

[bug] SQL file load shows shifted first line

INMOVES's profile image INMOVES posted 3 years ago in General

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

2 attachment(s):
  • hs_loaded
  • hs_highlight
INMOVES's profile image INMOVES posted 3 years ago

Using HeidiSQL 9.4.0.5130

Failed to add that 5133 did not solve this issue.

Frank

kalvaro's profile image kalvaro posted 3 years ago

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:

r0KcpvS.png" alt="Open file dialogue" />



Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
kalvaro's profile image kalvaro posted 3 years ago

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

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

kalvaro's profile image kalvaro posted 3 years ago

Grmmmmfff!

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

@Anse, is there something broken?

INMOVES's profile image INMOVES posted 3 years ago

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

ansgar's profile image ansgar posted 3 years ago

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

Please login to leave a reply, or register at first.