SQL Server Text Datatype Maxlength = 65,535?

that is a limitation of SSMS not of the text field, but you should use varchar(max) since text is deprecated

alt text

Here is also a quick test

create table TestLen (bla text)

insert TestLen values (replicate(convert(varchar(max),'a'), 100000))

select datalength(bla)
from TestLen

Returns 100000 for me

Tags:

Sql Server

Types

Text

Related