Hi all. Firstly off, excellent tool. Really loving it. Where has this been all my life?
Just thought I’d share my solution for inserting image BLOBs into SQL. It combines several techniques outlined in the help and forums, but might help someone get to the solution quicker (or maybe at all):
First step is that the field should be a “Base64 Image URL”.
Then use the following formula: code("cast(N'' as xml).value('xs:base64Binary(\"" + this[22..-1] + "\")', 'VARBINARY(max)')")
This worked for me using SQLv14. Hope this helps someone
(the [22..-1]
part removes the leading data:image/png;base64,
)