Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 ntext or nvarchar(max)

Author  Topic 

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2009-08-06 : 22:25:20
Hello,

I am including a database table from an open source project into my project. On a column of type ntext they are saving XML data.

Can or should I change it to nvarchar(max)?
I think it makes sense or not?

I am using SQL 2008.

Thanks,
Miguel

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-08-06 : 22:52:19
ntext is deprecated. use nvarchar(max) instead

see http://msdn.microsoft.com/en-us/library/ms187993.aspx




KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -