title: SQL Query to store text data in a Varbinary(max)
body: <p>Is there a way to make a varbinary accept text data in SQL Server?</p>
  
  <p>Here is my situation.  I have a fairly large amount of XML that I plan on storing in a "zipped" format.  (This means a Varbinary.)</p>
  
  <p>However, when I am debugging, I want to be able to flip a configuration switch and store in plain text so I can troubleshoot from the database (ie no client app to un-zip needed).</p>
  
  <p>Is it possible to insert normal text in to a varbinary(max)?</p>