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

Question

Hi All,

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

Answer 1

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

Answer 2

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