How to show binary image data from database on Vision Image component?

[Umesh_Shinde]

I am trying to show binary image data from Database on ignition vision image component.

[Hayden_Watson]

Look up this thread, might be useful:

Converting blob to image

Hi. Im using script to store filedata as varbinary(max) in mssqlserver. but the problems comes when im trying to display the image in perspective. im copying some of the scrips i see in some related topics I’m using this query to select and convert the blob to base64: SELECT CAST(’’ as xml).value(‘xs:base64Binary(sql:column(“filedata”))’, ‘varbinary(MAX)’) FROM files WHERE filename = ‘04E.JPG’ then this script transform to display the image: b64Image = “data:image/jpeg;base64,%s”%val…

[justinedwards.jle]

system.file.writeFile will convert the blob to an actual file. From there, you can do with it whatever you want. In your case, you just want to supply the path to your image component.

[pturmel]

@justinedwards.jle

convert the blob to an actual file

That's a terrible idea for this task. Numerous efficient solutions are posted on this forum that use the paintable canvas and take the blob data directly from a dataset.