cancel
Showing results for 
Search instead for 
Did you mean: 

Varbinary on Universe (Returns byte[16] instead of the original value)

zoe_zhou
Explorer
0 Kudos

Hi,

We have a VARBINARY data type column and would like to use it to create universe objects, but are not able to get its value correctly in IDT.

In Data Foundation - Connection it can recognize the data type as VARBINARY correctly, however if we choose it and select "show column values", the result we got is a list of "byte[16]" instead of the original value (like 0050568500391EE69AF63DEF2BED12E1)

And in Business Layer if we click "show value" it also returns "byte[16]". We tried to change the data type to "long text" as this post suggested but it did't work.

May be it's because of the data source? We used HANA, and actually in HANA view, we can see correct values in "Raw Data", however in "Analysis" it also returns "byte[16]". Is it because of the data conversion in HANA (see note 1761135 ) that we cannot retrieve original values? Any chance we can solve this problem?

Thanks,

Zoe

Accepted Solutions (0)

Answers (1)

Answers (1)

zoe_zhou
Explorer
0 Kudos

Managed to solve it with workaround. Add an additional column with VARCHAR data type and point it to the VARBINARY field. Values can now be retrieved.