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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |