Post reply

Best way to store HTML?

  • April 29, 2005 at 6:41 am

    #88898

    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.

  • April 29, 2005 at 6:49 am

    #555870

    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

  • April 29, 2005 at 6:52 am

    #555874

    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 3 (of 3 total)

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