Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers