cancel
Showing results for 
Search instead for 
Did you mean: 

BLOB insert into HANA Problem

Former Member
0 Kudos

I am trying to insert an image into HANA using the BLOB data type. I am creating a procedure then calling it to do the insert, but when I go to look at the data preview, the BLOB has been changed to something completely different and I dont know why(see pic). I have attached my SP and call statement. I would really appreciate some help on this. We're scheduled to display this funcitonality at FKOM.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

It's displaying your image as stored, in hex format. Presumably it's your image data which is wrong - the BLOB is just a binary object, it has no intelligence to the format.

You may find that it is easier to read the image from a file using the syntax from this thread: Unstructured Data in HANA | SAP HANA

John

P.S. If you want some traction around FKOM, you may want to ask an internal audience 🙂