cancel
Showing results for 
Search instead for 
Did you mean: 

HANA field Data Types NVARCHAR(1) or NVARCHAR(1000) best practice

Former Member
0 Kudos

dear all

i recently performed a test between two tables.

table1 had 1 field with a data type NVARCHAR(10), table 2 had 1 field with a data type NVARCHAR(1000).

i populated both tables with the same data and found they both consumed, exactly the same amount of memory.

so, here's the question.

assuming i do not need to use the width for limiting data or anything, why would i specify each field in a table with the width i would expect the field to contain. why don't i just have each field specified as NVARCHAR(1000), or something like that.

Accepted Solutions (0)

Answers (0)