REPLICATE( N'A', 4000000));
what is the meaning of N in N'A'? is it the maximum length.
I executed the below statements,
INSERT #t VALUES (1, REPLICATE( N'A', 4000000));
INSERT #t VALUES (2, REPLICATE( 'A', 4000000));
SELECT DATALENGTH(LongName) FROM #t
The result of the SELECT is
8000
16000
I don't know why i got 16000. Can anyone explain me?