[AMQ-6895] [SQLSever] Image data type is deprecated

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 5.15.2
• Component/s: AMQP, JDBC
• Labels: persistence
• Assignee: Unassigned
• Reporter: Evandro de Paula
• Created: 05/Feb/18 20:16
• Updated: 05/Feb/18 22:06

Description

Image data type is deprecated per link further below and it is used by column MSG on table ACTIVEMQ_MSGS on SQL Server or Azure SQL deployments.

Recommendation is to change it to varchar(max), nvarchar(max) or varbinary(max).

https://docs.microsoft.com/en-us/sql/database-engine/deprecated-database-engine-features-in-sql-server-2016