New feature: Image preview
I open the binary editor, hit "Load binary file" and select a GIF picture. I get this:
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?
Treat BLOBs like required in grid INSERTs and UPDATEs. Bug report: http://www.heidisql.com/forum.php?t=5883
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.
Please login to leave a reply, or register at first.