Get Images from SQL Anywhere DB through ODBC / OLE DB

[ElsKnockaert]

Good morning

I've tried to follow the steps of https://community.qlik.com/t5/Member-Articles/Loading-Image-files-stored-in-database-into-a-Qlik-Sen... to show the images I have in our DB in Qlik. But no luck. I'll include my steps and print screens to show you what I've done and hopefully someone can notice where I went wrong:

Data Connection works :

Load Script results in no errors :

MultiMedia_Content is a long binary in our database.

MultiMedia_Content_Type is  varchar(129) in our database and is either image/jpeg or image/bmp or image/png.

Result on sheet including possible filters:

MultiMedia_Content only shows 8 results while there are 55 pictures in our DB.

[ElsKnockaert · Accepted solution]

@JandreKillianRIC 

Brilliant! I used    base64_encode( ) in my SQL statement and => VICTORY! 

Thank you so much!

[JandreKillianRIC]

Amazing news!!! I dont have access to a SQL Anywhere site now to test so I was reading and reading and just thought - Lets just go with something like a convert! glad it helped!

Have a great day and happy building!