View Images from Database

[samer_samy]

Dears,
I cannot use TO_BASE64 in my mssql query as it is not recognized function :

 SELECT TO_BASE64(image1)
   from Images_v1 where PO='test1' 

I need to show the image stored in my sql db as you see below:

How to solve this pls

[pturmel]

If your database won't do it, and you are sure you do need to convert to base64 (you probably do not), then use jython to convert it after you get it into Ignition. See @Baris.kose's suggestion above.

[samer_samy]

As you said @pturmel ,No need for Base64 ,It worked as below