Best way to store HTML?

  • I am writing a little app that will store news items, such as press releases, events, headline stories, etc.  I was considering just putting each item into a nvarchar field, but that seems wrong for some reason.  How would you recommend that I accomplish this?

    BTW, I don't expect the data to get any longer than 8000 characters.

  • Then you can use varchar datatype. However, in Yukon you have 3 new datatypes : varchar(max), nvarchar(max) ans varbinary(max) where you can store upto 2GB of data.

    --Kishore

  • Will this be just as fast as if I spread the data out into 1000 character chunks into seperate records?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply