You can translate the question and the replies:

Blob Data Type in Denodo 6

Hi support Quick question... We have a few tables that were brought in from Oracle, which have blob (autodetect) fields. I did some reading and it looks like I can still use them in a join condition, pending they are of "varbinary" type (which they are), but it would be very helpful to see the actual values, like you can from oracle. So from VDP admin I see "[Binary Data] - 16 bytes" or from a SQL tool I see " H…DZu @ÌZ PV÷`ó"... but from Oracle I see somehing like "1E41111861EF0F909B78005011186094". Realize this might be specific to Oracle, but is there any way to expose the true value of this file, like Oracle can? Thanks
blob oracle database connection
user
20-12-2016 17:10:12 -0500
code

1 Answer

Hi, Denodo Platform is not able to do a cast from blob type (which represents binary strings) to any of the numeric data types supported by Denodo, however, it is possible to do a cast from blob type to text type. Anyway, if you still need to see the value in the same way than Oracle does you can develop a custom function implementing the same transformation than Oracle does with the varbinary data type. Hope this helps!
Denodo Team
21-12-2016 06:16:57 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here