title: What is difference between ntext and varchar in SQL Server 2008 R2
body: <p>I want to know basic difference between datatype of <code>ntext</code> and <code>varchar</code> in SQL Server 2008 R2. And in what situation should I use <code>ntext</code> and <code>varchar</code> </p>