ODBC target data types
The following table shows the ODBC target data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types.
ODBC does not support applying changes to binary data types in Batch optimized apply mode. For more information on Batch optimized apply mode, see Change Processing Tuning.
For information on how to view the data type that is mapped from the source, see the section for the source endpoint you are using.
For additional information about Qlik Replicate data types, see Replicate data types.
| Qlik Replicate Data Types | ODBC Data Types |
|---|---|
|
BOOLEAN |
SQL_BIT |
|
BYTES |
SQL_VARBINARY |
|
DATE |
SQL_TYPE_DATE |
|
TIME |
SQL_TYPE_TIME |
|
DATETIME |
SQL_TYPE_TIMESTAMP |
|
INT1 |
SQL_SMALLINT |
|
INT2 |
SQL_SMALLINT |
|
INT4 |
If the target endpoint supports precision and scale then: SQL_INTEGER Otherwise: SQL_VARCHAR |
|
INT8 |
SQL_BIGINT |
|
NUMERIC |
SQL_NUMBER |
|
REAL4 |
SQL_REAL |
|
REAL8 |
SQL_DOUBLE |
|
STRING |
SQL_VARCHAR |
|
UINT1 |
SQL_TINYINT |
|
UINT2 |
SQL_SMALLINT |
|
UINT4 |
SQL_INTEGER |
|
UINT8 |
SQL_BIGINT |
|
WSTRING |
SQL_WVARCHAR |
|
CLOB |
CLOB |
|
BLOB |
BLOB |
If the target endpoint does not support ODBC data types, data types are mapped to SQL_VARCHAR.