New feature: Image preview

User, date Message
User: anse
Posted: Fri, 04 Jun 10 01:39
Category: News
1821 posts since Fri, 07 Apr 06 		Users of HeidiSQL 3.x may have missed this feature since grid and BLOB editing was rewritten for v4: A preview area for images. Now it's even more powerful than before: it detects and loads various kinds of images (JPG, PNG, GIF, BMP, PSD, TIF and more). Also, the new preview area does not take valuable space when you're in some grid, as it's placed below the database tree:
User: kalvaro
Posted: Fri, 04 Jun 10 09:20
145 posts since Thu, 29 Nov 07 		For me, it always displays "No image detected" but I'd dare say it's because pictures are not uploaded properly.

I open the binary editor, hit "Load binary file" and select a GIF picture. I get this:

47494638396166002900C40000BFDDE...

When I hit "Apply changes" this query is run:

UPDATE `usuario` SET `foto`='0x4749463839616600...

The value should not be quoted. The column is of BLOB type. Any clue of what I'm doing wrong?
User: anse
Posted: Fri, 04 Jun 10 10:29
1821 posts since Fri, 07 Apr 06 		Yes, looks like a quoting bug. If you upload files via Import > "Insert files ..." this does not happen.
User: anse
Posted: Fri, 04 Jun 10 20:19
1821 posts since Fri, 07 Apr 06 		Fixed in r3378.
User: kalvaro
Posted: Mon, 07 Jun 10 18:23
145 posts since Thu, 29 Nov 07 		That was quick smile Now I get this (correct) query:

UPDATE `usuario` SET `foto`=_binary 0x47494638396166004500C4...



But I've noticed another weird issue (sorry!). The image preview works fine when running a SELECT query from a "Query" tab but I cannot see pictures from the "Data" tab. When I insert a GIF the grid displays "0x307834373439" even though the log shows that 0x4749463839616 was actually inserted and the preview pane shows "No image detected". If I refresh the grid I see "GIF89a..." on the grid and the preview page shows the image info ("GIF: 102x51 pixels, 100%, 175B") but the picture itself is empty.
User: anse
Posted: Mon, 07 Jun 10 19:40
1821 posts since Fri, 07 Apr 06 		Yes, that's because the data tab grid needs a hit before it detects that as BLOB field and gets the whole data. That happens when you start editing some field, no matter which one. Of course that's not the way it should stay, I'll tweak that soon.
User: anse
Posted: Mon, 07 Jun 10 19:43
1821 posts since Fri, 07 Apr 06 		As soon as issue #1948 is solved that should be working more as expected.
User: anse
Posted: Fri, 11 Jun 10 21:55
1821 posts since Fri, 07 Apr 06 		I just fixed issue #1948.
 

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