Skip to Content
Author's profile photo Muthuram Shanmugavel

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.

temp1.PNG

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.

temp3.PNG


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.

Temp2.PNG

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

Thanks & Regards,

Muthu

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Manikandan Marimuthu
      Manikandan Marimuthu

      Good effor Muthu to start with. It is simple to read and understand a HANA capability or concept in less than 2 minutes.waiting for more simple articles from you like this.

      A suggestion - you can even rename the topic something like this.

      HANA Concepts Example 1 - CLOB and BLOB how it looks.

      HANA Concepts Example 2 - XXXXX

      Author's profile photo Former Member
      Former Member

      Thank you, Please can you shed some light on NCLOB as well? thanks