Last post Sep 06, 2016 12:45 PM by Mikesdotnetting
Member
10 Points
23 Posts
Sep 06, 2016 12:30 PM|Mounesh|LINK
Hi All ,
Do i need to specify the datalegth while declaring the Ntext datatype in SQL for a column otherwise what issues it can produce
All-Star
192718 Points
27925 Posts
Moderator
Sep 06, 2016 12:45 PM|Mikesdotnetting|LINK
You should avoid using ntext: https://msdn.microsoft.com/en-GB/library/ms187993.aspx
You cannot specify a length for ntext. It doesn't accept arguments like varchar or nvarchar.
Member
10 Points
23 Posts
NText Datatype issue in SQL
Sep 06, 2016 12:30 PM|Mounesh|LINK
Hi All ,
Do i need to specify the datalegth while declaring the Ntext datatype in SQL for a column otherwise what issues it can produce
All-Star
192718 Points
27925 Posts
Moderator
Re: NText Datatype issue in SQL
Sep 06, 2016 12:45 PM|Mikesdotnetting|LINK
You should avoid using ntext: https://msdn.microsoft.com/en-GB/library/ms187993.aspx
You cannot specify a length for ntext. It doesn't accept arguments like varchar or nvarchar.