Project

General

Profile

Actions

Task #1665

open

Use of deprecated datatype "image" when using MSSQL

Added by Petr Fišer almost 5 years ago. Updated almost 5 years ago.

Status:
New
Priority:
Normal
Assignee:
Ondřej Kopr
Category:
Database
Target version:
-
Start date:
05/17/2019
Due date:
% Done:

0%

Estimated time:
Owner:

Description

Since Q3/2017, Microsoft deprecated the "image" datatype in MS SQL Server. CzechIdM uses this datatype in various places and we should consider changing them to supported datatypes (e.g. varbinary).
Source: https://docs.microsoft.com/en-us/sql/t-sql/data-types/ntext-text-and-image-transact-sql?view=sql-server-2017 .

Ondra tested this and we can safely transform the datatype of a column in the Flyway with:

ALTER TABLE t ALTER COLUMN c VARBINARY(somesize | MAX) ...;

Assigning to Ondra: please plan it for some future product release. Thx

Actions #1

Updated by Petr Fišer almost 5 years ago

  • Description updated (diff)
Actions

Also available in: Atom PDF