title: Is storing HTML as blob information in SQL Server a good idea?
body: <p>Is is a good idea to store an HTML string as blob data in SQL server or should we keep it as a string? Currently, we do not have a need to search the data in the HTML. Also, for security reasons we do not want to store the files on the file system or any external storage. That is why we have opted for storing the data in SQL.</p>
  
  <p>I'd like to know if there is significant overhead to store this type of data as a blob or if we should just keep it as plain text in the database.</p>
  
  <p>I do not feel this is a duplicate question as I am asking if storing HTML as a blob is a good idea or not. I found <a href="https://stackoverflow.com/questions/7626585/storing-html-in-mysql-blob-or-text">this question</a>, while it pertains to MySQL, perhaps it could be applied to SQL Server. Could there be a legitimate use for blobs and HTML? </p>