What's the difference between ntext and nvarchar(max) in sqlserver????
Loading
What's the difference between ntext and nvarchar(max) in sqlserver????
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Kirtan PatelPosted Feb 17, 2010, 7:31 AM
Ntext Stores text As LOB ( Large Object Structure ) in database while NVARCHAR behaves by default store text in table structure and behaves like NTEXT (LOB Structure ) only when it exceeds 8000 Bytes .
so better to use NVARCHAR()
if it solves your doubt please mark "Do you like this answer " check box :)
Lalit MPosted Feb 18, 2010, 1:33 AM
Hirendra SisodiyaPosted Feb 18, 2010, 1:23 AM