October 4, 2006 at 2:29 pm
October 6, 2006 at 7:45 am
According to MS, "ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead"
So we don't have choice here.
varchar(max) , nvarchar(max) etc are easier to use than BLOB, actually they can be used in the same way as nvarchar(n), n is a number.
In terms of performance, I don't see any benchmark. But they should be comparable if not better I guess.
October 6, 2006 at 12:25 pm
Thank you, peterhe!
Igor
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply