Article Details
Id: | 15062 |
Product: | finPOWER Connect |
Type: | NEW |
Version: | 3.01.00 |
Opened: | 21/06/2017 |
Closed: | 15/11/2017 |
Released: | 23/02/2018 |
Job: | J019209 |
![]() |
SQL Server; change all "TEXT" columns to "VARCHAR(MAX)"
Long text (Memo) type columns in SQL Server use a data type of "TEXT" Unfortunately this data type will be removed in a future version of SQL Server.
Therefore all "TEXT" columns have been updated to "VARCHAR(MAX)".
For more information see https://docs.microsoft.com/en-us/sql/t-sql/data-types/ntext-text-and-image-transact-sql.