Skip to Content

Revert BLOB to VARBINARY

Hi All,

From below notes, we can convert VARBINARY to BLOB, but can we revert the change back to VARBINARY after converted to BLOB?

2220627 - FAQ: SAP HANA LOBs

2375917 - How-To: Converting SAP HANA VARBINARY columns to LOB

Reason of asking is we would like to convert the CLUSTD column from VARBINARY to BLOB as it consume huge amount of HANA memory (200++GB) and afraid we need to reverse it incase of any query performance degradation and implication...

Your kind input is very much appreciated.

Thanks!
Nicholas Chang

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 13 at 04:22 AM

    Note 2375917 makes it clear that a copy of the old table structure with VARBINARY has to be kept until the conversion success including performance aspects has been verified. Instead of converting back and forth that should be the fallback option.

    Also, this conversion effort, as any other changes, should be done on DEV and QA systems before the production system. If there's any doubt about the success of the change in either of these systems, don't push it to production.

    Finally, yes it is possible to change data from LOB to VARBINARY as long as the size of the data fits into VARBINARY fields.


    Add comment
    10|10000 characters needed characters exceeded