Thursday 11 February 2016

BLOB and CLOB Data Types - How Data Preview Looks - Example

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.

SAP HANA BLOB and CLOB

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.

SAP HANA CLOB, SAP HANA BLOB

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.

SAP HANA Certifications

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

Source: scn.sap.com

No comments:

Post a Comment