Confluence uses deprecated data type for SQL Server and Azure SQL databases

Issue Summary

Confluence uses deprecated data type for SQL Server and Azure SQL databases

• Tested in Confluence 7.4 and also 7.9
• Tested with SQL Server 2017
• Customer also sees it in Azure SQL

Steps to Reproduce

1. Install a Confluence vanilla instance running against SQL Server
2. Once installed, check the data type for BODY column in BODYCONTENT table

Also noticed this data type is used for BANDANAVALUE column in BANDANA table

Expected Results

You'd see a data type supported by the current database version

Actual Results

The data type is ntext which has been deprecated in SQL Server and will be removed soon as mentioned in this ntext, text, and image (Transact-SQL) - SQL Server page.

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.

Workaround

Currently there is no known workaround for this behavior. A workaround will be added here when available