tags:

views:

37

answers:

1
+1  Q: 

Which column type should I use for storing HTML of an unknown size?

What column type should I use for storing html content from a website with an unknown size?

(I'm scanning certain html pages, and create an database entry if there are changes between the last stored entry and the current html code.)

My database is a MSSQL 2008 express database.

+4  A: 

Use varchar(max)

Ray  2010-04-03 16:54:08
+1. Or potentially `nvarchar(max)` if you are worried about Unicode chars. It may also be worth noting that `text` has been deprecated in favour of this :)
Amadiere  2010-04-03 16:56:02
you can also use a text column, but varchar(max) is soooo much easy, you can use all the string functions directly on a varchar(max) field...
opensas  2010-04-03 16:56:22
@Amadiere: thanx - I forgot nvarchar(max)
Ray  2010-04-03 16:57:34
thanks. I'll go with that
citronas  2010-04-03 16:58:08

related questions

Autosizing Textarea
Regular expression for parsing links from a webpage?
What are good tools for creating compiled HTML help files (.chm)?
Looking for WYSIWYG HTML editor
Any reason not to start using the HTML 5 doctype?
HTML comments break down
HTML Comments Markup
Setting a div's height in HTML with CSS
Wrapping lists into columns
Is a "Confirm Email" input good practice when user changes email address?
<XMP> Tag
HTML version choice
Options for HTML scraping?
How do you disable browser Autocomplete on web form field / input tag?
How do I make a checkbox toggle from clicking on the text label as well?
Html CSS Editor
Wordpress theme development offline tools
How do I give my web sites an icon for iPhone?
In HTML, how to word-break on a dash?
Detecting font in JavaScript
How do you test layout design across multiple browsers/OSs?
How do I print an HTML document from a web service?
Multiple submit buttons on a HTML form
How can I determine a web user's time zone?
Why doesn't the percentage width child in absolutely positioned parent work in IE7?