CODEWITHSUNDEEP
sqlt-sqlsql-server-2008
scarpacci
scarpacci

Reputation: 9194

Use varbinary(max) to store HTML? SQL Server 2008

I am trying to figureout the best solution to store html data in some of my tables and track the history of changes made to that HTML. I read that text, ntext, etc are no longer supported for AFTER Triggers so I was thinking of using the varbinary(max) instead. Has anyone used varbinary to store HTML? I was planning on tracking the changes using a trigger to write off the history when the HTML is updated.

As always I greatly appreciate the input....the feedback I get is always great.

Thanks,

S

Upvotes: 1

Views: 779

Answers (2)

Ray
Ray

Reputation: 21905

using varchar(max) would be more logical - it is made for textual data and you can us string processing functions with it.

Upvotes: 3

Kirk Woll
Kirk Woll

Reputation: 77546

Why not varchar(max) or nvarchar(max) instead?

Upvotes: 2

Related Questions