What is difference between ntext and varchar in SQL Server 2008 R2

Question

I want to know basic difference between datatype of ntext and varchar in SQL Server 2008 R2. And in what situation should I use ntext and varchar

http://stackoverflow.com/questions/2133946/nvarcharmax-vs-ntext — David Brabant, Jul 19 '13 at 05:26
Easy: **don't use** `ntext` anymore. Also: `varchar` = non-Unicode, `nvarchar` = Unicode (2 bytes per character) — marc_s, Jul 19 '13 at 05:31

score 13 · Accepted Answer · answered Jul 19 '13 at 05:27

13

From ntext, text, and image (Transact-SQL) i think that the biggest difference that should concern you is

ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them.

answered Jul 19 '13 at 05:27

Adriaan Stander

162,879
31
289
284

1

This is not an answer to the main question, but a strong recommendation. – user2063329 Jul 20 '17 at 03:29

What is difference between ntext and varchar in SQL Server 2008 R2

1 Answers1

Linked