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
High Importance

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.