I am going to show example --> How data preview looks for BLOB and CLOB data types.
I have created table with columns having BLOB and CLOB data types.
I have created table with columns having BLOB and CLOB data types.
I have inserted the unstructured data to both columns (same data). Then I have checked the data preview of the table.
Text I Inserted (Starts With): Strong demand ..
Column having CLOB Data Type: It shows the same value as I inserted. (String Format)
Column Having BLOB Data Type: It shows the value in Hexadecimal Format - (Hexadecimal Value calculated based on Binary digits)