Microsoft SQL Server target data types
Last updated: 8/26/2026The Microsoft SQL Server target for Qlik Replicate supports most Microsoft SQL Server data types. The following table shows the Microsoft SQL Server target data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types.
For information on how to view the data type that is mapped from the source, see the section for the source database you are using.
For additional information about Qlik Replicate data types, see Replicate data types.
When replicating to Microsoft SQL Server 2019 or 2022, UTF-8 data can be transferred to VARCHAR, CHAR, and CLOB columns when the database collation is set to %collation%_UTF8 (for example, Latin1_General_100_CI_AS_SC_UTF8). When working with an earlier Microsoft SQL Server version or a different collation, use a transformation (global or table-specific) to transform the column data type to WSTRING.
See also Using the Transform tab and Defining global rules.
| Qlik Replicate data types | Microsoft SQL Server data types |
|---|---|
|
BOOLEAN |
TINYINT |
|
BYTES |
VARBINARY(length) |
|
DATE |
DATE |
|
TIME |
TIME(0) |
|
DATETIME |
If scale is 0-7, then: DATETIME2 (Scale) If scale exceeds 7, then: DATETIME2 (7) |
|
INT1 |
SMALLINT |
|
INT2 |
SMALLINT |
|
INT4 |
INT |
|
INT8 |
BIGINT |
|
NUMERIC |
NUMERIC(p,s) |
|
REAL4 |
REAL |
|
REAL8 |
FLOAT |
|
UINT1 |
INT2 |
|
UINT2 |
INT4 |
|
UINT4 |
INT8 |
|
UINT8 |
NUMERIC(20) |
|
STRING |
If column is date or time then: DATETIME2 If the column is not a date or time: VARCHAR(length) Information noteIf subtype is JSON, and the Microsoft SQL Server version is 2025, then JSON
|
|
WSTRING |
NVARCHAR(length) Information noteIf subtype is JSON, then JSON
|
|
CLOB |
VARCHAR(max) TEXT To use this data type with Qlik Replicate, you must enable the use of CLOBs for a specific task. Information noteIf subtype is JSON, then JSON
|
|
NCLOB |
NVARCHAR(max) NTEXT To use this data type with Qlik Replicate, you must enable the use of CLOBs for a specific task. Information noteIf subtype is JSON, then JSON
|
|
BLOB |
VARBINARY(max) IMAGE To use this data type with Qlik Replicate, you must enable the use of BLOBs for a specific task.
|