SQL Server text, text type, image data type

Question

Microsoft announced that " ntext, textand imagedata types will be removed in a future version of Microsoft SQL Server". And we recommend using instead nvarchar(max), varchar(max)and varbinary(max).

My question is: I have a data type greater than 8 kb. How can I insert this data into sql? What type of data will solve my problem?

MSDN Datatype Document

Answer 1

Any of nvarchar (max) , varchar (max) and varbinary (max) .

nvarchar (max) varchar (max) ( nvarchar Unicode).

varbinary (max) - (, ..).

MAX indicates that the maximum storage size is 2^31-1 bytes.

Answer 2

, varchar(max), nvarchar(max) ( unicode). varchar (max) 2 ^ 31-1 (Ref.)

, varbinary(max).

Answer 3

nvarchar(max), varchar(max) varbinary(max)

, 8KB, ROW_OVERFLOW_DATA.

MSDN .

, varchar (max) 2 .

Answer 4

"varchar".

, varchar(max), varchar (50) or varchar (1000) or varchar (8000) `.

• (max) 2 ^ 32-1
• -max- 8000 .

, varchar(50) varchar(1000) upto varchar(8000), varchar(max).

"max" "50" / "1000" / "8000" + .

, , .