July 11, 2017 at 9:52 am
I thought the text data type was deprecated in sql 2016? Anybody know why this occurs?
July 11, 2017 at 10:02 am
The text data type has been deprecated since 2008. This does not mean, however, that it has been removed. Deprecated means that the functionality will be removed in a future version of SQL Server, and thus, you should begin to use other functionality. In the case of (n)text, use (n)varchar(max), and varbinary for image.
Consider, otherwise, that if deprecated features were removed, the amount of systems that would have completely fallen over with 2008; not terminating your statements with a semi colon ( ; ) was also deprecated in that version.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 11, 2017 at 10:02 am
I also tried changing the compatibility level to 2016 and restarted the services and it still did not change.
July 11, 2017 at 10:07 am
JP10 - Tuesday, July 11, 2017 10:02 AMI also tried changing the compatibility level to 2016 and restarted the services and it still did not change.
Thom has already explained why, I believe.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
July 11, 2017 at 10:08 am
JP10 - Tuesday, July 11, 2017 10:02 AMI also tried changing the compatibility level to 2016 and restarted the services and it still did not change.
Using 2016 compatibility will make no difference. Even in SQL Server 2017 (CTP) you can still create columns of data type text.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 11, 2017 at 10:10 am
Thanks Thom. Interesting so why even say it's going to be deprecated when they have been saying that since 2008? haha Appreciate the information guys.
July 11, 2017 at 10:13 am
Just incase, to quote from Microsoft Docs:
ntext, text and image (Transact-SQL)
IMPORTANT!
ntext, text, and image data types will be removed in a future version of SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.
Underlined for emphasis.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 11, 2017 at 10:17 am
JP10 - Tuesday, July 11, 2017 10:10 AMThanks Thom. Interesting so why even say it's going to be deprecated when they have been saying that since 2008? haha Appreciate the information guys.
Because people have notice to make changes. Considering that people are still using SQL server 2005, some are much slower to make changes than others.
Personally, at my current workplace, we still have 2 systems that make use of the image datatype, and our core system doesn't terminate its statements with semicolons. We're now 9 years after the feature was deprecated. Some things take (a lot of) time, and so, some of the more prominent features that are deprecated don't go into the "breaking changes" until a long time after it was deprecated.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 11, 2017 at 10:25 am
thanks for the reminder of this whole process!
July 11, 2017 at 1:48 pm
Thom A - Tuesday, July 11, 2017 10:02 AMThe text data type has been deprecated since 2008.
Since 2005.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply