Skip to main content
pdf?stylesheet=default
Blackboard Help

MS SQL Data Type Changes

Microsoft SQL has de-supported certain data types. IThe Learn installer has been modified to alter the Learn schema in support of the new datatypes. Building Blocks utilizing the de-supported data types should be refactored to support the new data types.

MS SQL Data Type Changes

Certain data types have been de-supported in MS SQL. The following table provides the replacement data types:

De-supported Data Type New Data Type
text varchar(max)
ntext nvarchar(max)
image varbinary(max)

Note that ntext is mapped to nvarchar(max), text is mapped to varchar(max), and image is mapped to varbinary(max)

Building Blocks Impact

Building Blocks using the de-supported data types should be refactored to support the new data types and thouroughly tested.

Updater Impact

For optimal performance the Learn Installer/Updater requires 25% more database space in advance of performing the update to support the data type migration.