Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
muthuram_shanmugavel2
Contributor

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 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)


String - Strong demand, Binary value and Hexadecimal value are listed below as per ASCII standard.


As per this table, Strong demand in Hexadecimal form is --> 5374726F6E672064656D616E64

We will check data preview in HANA table now.

Hexadecimal content is shown for BLOB column and string content is shown for CLOB data types for the same texts.

I hope that you would have got the understanding that How BLOB and CLOB data types storage behaves.

Thanks & Regards,

Muthu

2 Comments
Labels in this area