# Supported data types

The following table shows the Microsoft Fabric Data Warehouse 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](https://help.qlik.com/en-US/replicate/November2024/Content/Replicate/Main/Endpoints/att_rep_data_types.htm).

Supported data types

| Replicate data types | Microsoft Fabric Data Warehouse data types |
| --- | --- |
| BOOL | BIT |
| BYTES | If length is 1-8000, then:<br><br>VARBINARY (Length in Bytes)<br><br>If length exceeds 8000, then:<br><br>VARBINARY (8000) |
| DATE | DATE |
| TIME | If scale is 0-6, then:<br><br>TIME (Scale)<br><br>If scale exceeds 6, then:<br><br>TIME (6) |
| TIMESTAMP | If scale is 0-6, then:<br><br>DATETIME2 (Scale)<br><br>If scale exceeds 6, then:<br><br>DATETIME2 (6) |
| INT1 | SMALLINT |
| INT2 | SMALLINT |
| INT4 | INT |
| INT8 | BIGINT |
| NUMERIC | DECIMAL (p,s) |
| REAL4 | FLOAT(24) |
| REAL8 | FLOAT(53) |
| STRING | If length in bytes is 1-8000, then:<br><br>VARCHAR (Length in Bytes)<br><br>If length in bytes exceeds 8000, then:<br><br>VARCHAR (8000) |
| UINT1 | SMALLINT |
| UINT2 | INT |
| UINT4 | BIGINT |
| UINT8 | DECIMAL (20,0) |
| WSTRING | If length in bytes is 1-8000, then:<br><br>VARCHAR (Length in Bytes)<br><br>If length in bytes exceeds 8000, then:<br><br>VARCHAR (8000) |
| BLOB | VARBINARY (8000)<br><br>Information note<br><br><ul> <li>VARBINARY (8000) applies to the entire record. So, for example, if the record contains two BLOB columns, their total size cannot exceed 8000 bytes.</li> <li>When capturing changes, the maximum number of bytes that can be captured is 4000.</li> </ul> |
| NCLOB | VARCHAR (8000) |
| CLOB | VARCHAR (8000) |

Information noteFull LOB data types are not supported. For information on including Limited-size LOB data types in the replication, see the [Metadata](https://help.qlik.com/en-US/replicate/November2024/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_metadata.htm) tab description in [Customizing tasks](https://help.qlik.com/en-US/replicate/November2024/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/cust_tasks.htm).