Image preview.

starf's profile image starf posted 15 hours ago in General Permalink

Hello, I just discovered the preview as image functionality. It's great to display images in blob columns.

I also encounter some annoying points :

  • if the table has a primary key, the preview requires two selection operations of the same row, because the default select operation truncates blob columns with a left 256.
  • when I remove the primary key, the image preview works at the first selection operation, but then it becomes impossible to edit or drop lines.

Any clue to circumvent theses annoying points ?

Thanks.

ansgar's profile image ansgar posted 15 hours ago Permalink

No. And I think if HeidiSQL would not do the first "annoying point" you mention, you were even more annoyed, due to a laggy performance.

starf's profile image starf posted 14 hours ago Permalink

Hello Ansgar, thank you for replying.

Of course, I totally understand the usefulness of the left 256, that's not the point, I was just wanting to know if there was something somewhere I can adjust to avoid these points.

Also, since you are replying, maybe a little adjustment in the code of the Image preview function can resolve the first point, if, for example, you do the preview After reloading the line for editing ? Thanks.

ansgar's profile image ansgar posted 14 hours ago Permalink

Oh I just see the issue - the preview is not refreshed after the full-row-load. I guess this is what you mean.

Could you please file a bug report in the tracker?

starf's profile image starf posted 13 hours ago Permalink

Done. :)

ansgar's profile image ansgar posted 13 hours ago Permalink

Thank you. Issue #2038

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