title: SQL 2008 - varchar(max) vs text data types
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/564755/sql-server-text-type-vs-varchar-data-type">SQL Server Text type vs. varchar data type</a><br>
    <a href="https://stackoverflow.com/questions/834788/using-varcharmax-vs-text-on-sql-server">Using varchar(MAX) vs TEXT on SQL Server</a>  </p>
  </blockquote>
  
  
  
  <p>from this article, it looks like they both have the same size capacity: <a href="http://msdn.microsoft.com/en-us/library/ms143432.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms143432.aspx</a></p>
  
  <p>is that truly correct? what are the real differences?</p>
  
  <p>i just migrated some data from oracle (clob and made it into a varchar(max), but it looks like it truncated some of the values anyway, should i use TEXT instead?</p>
  
  <p>Thank you!</p>