How much size does the VARCHAR takes- the defined size or the size of the content in SAP HANA?


I am not sure whether someone can get you exact answer, SAP is not open source and implementation details and bits are not known to many except the creators and few others. If I go with the standard definition, for storage you will require the size of length of the data plus number of bytes for header information. So as per your example it will require 9 + 2 (for header) = 11 overall for storage.

Updated on 30-Jul-2019 22:30:20