We are developing an Intranet for our organization and are using SQL 7.0 as the database for it. We have a content table with a field to hold the text for the various html pages. Can somebody explain to me the difference between the text and ntext datatypes? Which is better to use for storing web page content? Also, what is the difference between varchar and nvarchar? I couldn't seem to find any clear-cut explanation of the differences.