Skip to Content
0

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

Dec 05, 2016 at 01:11 PM

88

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers