# Supported data types

The following table shows the supported Microsoft SQL Server source data types and their default mapping to Replicate data types.

When replicating to a Microsoft SQL Server-based target, the source and target data types are the same, apart from the exceptions described in [Homogeneous replication](https://help.qlik.com/en-US/replicate/November2025/Content/Replicate/Main/MySQL/homogeneous_replication.htm).

For information on how to view the data type that is mapped in the target, see the section for the target endpoint you are using.

For additional information about Replicate data types, see [Replicate data types](https://help.qlik.com/en-US/replicate/November2025/Content/Replicate/Main/Endpoints/att_rep_data_types.htm).

Information note

When row size exceeds 8060, the VARCHAR, NVARCHAR, and VARBINARY data types will be stored out-of-row. To replicate such data, use the source lookup function described in [Data Enrichment](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_expressOther.htm#Data2).

Information note

Collatable data types are indicated by an asterisk (\*).

Supported source data types

| Microsoft SQL Server data types | Replicate data types |
| --- | --- |
| BIGINT | INT8 |
| BIT | BOOLEAN |
| DECIMAL | NUMERIC |
| INT | INT4 |
| MONEY | NUMERIC (19,4) |
| NUMERIC (p,s) | NUMERIC |
| SMALLINT | INT2 |
| SMALLMONEY | NUMERIC (10,4) |
| TINYINT | UINT1 |
| REAL | REAL4 |
| FLOAT | REAL8 |
| DOUBLE | REAL8 |
| DATETIME | DATETIME |
| DATETIME2 | DATETIME |
| SMALLDATETIME | DATETIME |
| DATE | DATE |
| TIME | STRING (16) |
| DATETIMEOFFSET | STRING |
| \*CHAR | STRING |
| \*VARCHAR | STRING |
| \*VARCHAR (max)<br><br>\*TEXT<br><br>To use this data type with Qlik Replicate, you must enable the use of CLOBs for a specific task.<br><br>LOB columns for Microsoft SQL Server tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft SQL Server. | CLOB |
| \*NCHAR | WSTRING |
| \*NVARCHAR (length) | WSTRING |
| \*NVARCHAR (max)<br><br>\*NTEXT<br><br>To use this data type with Qlik Replicate, you must enable the use of NCLOBs for a specific task.<br><br>LOB columns for Microsoft SQL Server tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft SQL Server. | NCLOB |
| BINARY | BYTES |
| VARBINARY | BYTES |
| VARBINARY (max)<br><br>IMAGE<br><br>To use this data type with Qlik Replicate, you must enable the use of BLOBs for a specific task.<br><br>LOB columns for Microsoft SQL Server tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft SQL Server. | BLOB |
| TIMESTAMP | BYTES |
| UNIQUEIDENTIFIER | STRING |
| HIERARCHYID | VARCHAR (x) |
| XML<br><br>LOB columns for Microsoft SQL Server tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft SQL Server.<br><br>To use this data type with Qlik Replicate, you must enable the use of NCLOBs for a specific task. | CLOB |
| GEOMETRY | NCLOB |
| GEOGRAPHY | NCLOB |

## Unsupported data types

The following data types are not supported:

* CURSOR
* SQL\_VARIANT
* TABLE

Information note

User-defined data types are supported according to their base-type. For example a user-defined data type based on DATETIME is handled as a DATETIME data type.