DBA: TEXT and BLOB fields on SQL Server

Description

The native data types used to create BLOB and TEXT type fields have been updated. In particular:

• The BLOB fields are now created as "varbinary(max)" (in previous versions of Instant Developer they were created as "image")
• The TEXT fields are now created as "varchar(max)" and "nvarchar(max)" depending whether or not the "Unicode" flag is activated in the database (in previous versions of Instant Developer they were created as "text" and "ntext" respectively).

As indicated in this article, the native types IMAGE, TEXT, and NTEXT are obsolete and will be removed in a future version of SQL Server.

Features involved

The creation and maintenance of the SQL Server database schema.

Notes

• Improvement related to support request 001888-2021.
• The new data types are only activated if the database type is set to SQL Server 2005-2012. This selection is automatic if the database types are not shown and "SQL Server" is selected in the list of database types.