ODBC source data types

The following table shows the ODBC source 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 in the target, see the section for the target endpoint you are using.

For additional information about Qlik Replicate data types, see Replicate data types.

Supported data types
ODBC Data Types	Qlik Replicate Data Types
SQL_BIT	BOOLEAN
SQL_TINYINT	INT1 UINT1 SQL data types are mapped to unsigned data types when the `UNSIGNED_ATTRIBUTE` is set to `SQL_TRUE` for the data type being mapped.
SQL_SMALLINT	INT2 UINT2 SQL data types are mapped to unsigned data types when the `UNSIGNED_ATTRIBUTE` is set to `SQL_TRUE` for the data type being mapped.
SQL_INTEGER	INT4 UINT4 SQL data types are mapped to unsigned data types when the `UNSIGNED_ATTRIBUTE` is set to `SQL_TRUE` for the data type being mapped.
SQL_BIGINT	INT8 UINT8 SQL data types are mapped to unsigned data types when the `UNSIGNED_ATTRIBUTE` is set to `SQL_TRUE` for the data type being mapped.
SQL_DOUBLE	REAL8
SQL_FLOAT	REAL8
SQL_REAL	REAL8
SQL_NUMERIC (P,S)	NUMERIC (P,S) REAL8 The SQL_NUMERIC data type is mapped to REAL8 when at least one of the following is true: Precision > 38 Scale < 0 Scale > 38 Scale > Precision
SQL_DECIMAL (P,S)	NUMERIC (P,S) REAL 8 The SQL_NUMERIC data type is mapped to REAL8 when at least one of the following is true: Precision > 38 Scale < 0 Scale > 38 Scale > Precision
SQL_DATE SQL_TYPE_DATE	DATE
SQL_TIME SQL_TYPE_TIME	TIME
SQL_TIMESTAMP SQL_TYPE_TIMESTAMP	DATETIME
SQL_CHAR SQL_VARCHAR	STRING
SQL_WCHAR SQL_WVARCHAR	WSTRING
SQL_LONGVARCHAR Information note To use this data type with Qlik Replicate, you must enable the use of CLOBs for a specific task. During CDC or during Full Load when the Allow unlimited LOB size option is enabled, LOB data types are supported only in tables with a primary key or unique index.	CLOB
SQL_WLONGVARCHAR Information note To use this data type with Qlik Replicate, you must enable the use of NCBLOBs for a specific task. During CDC or during Full Load when the Allow unlimited LOB size option is enabled, LOB data types are supported only in tables with a primary key or unique index.	NCLOB
SQL_BINARY	BYTES
SQL_LONGVARBINARY Information note To use this data type with Qlik Replicate, you must enable the use of BLOBs for a specific task. During CDC or during Full Load when the Allow unlimited LOB size option is enabled, LOB data types are supported only in tables with a primary key or unique index.	BLOB
SQL_GUID	STRING
SQL_INTERVAL_YEAR SQL_INTERVAL_MONTH SQL_INTERVAL_DAY SQL_INTERVAL_MINUTE SQL_INTERVAL_HOUR SQL_INTERVAL_SECOND SQL_INTERVAL_YEAR_TO_MONTH SQL_INTERVAL_DAY_TO_HOUR SQL_INTERVAL_DAY_TO_MINUTE SQL_INTERVAL_DAY_TO_SECOND SQL_INTERVAL_HOUR_TO_MINUTE SQL_INTERVAL_HOUR_TO_SECOND SQL_INTERVAL_MINUTE_TO_SECOND	STRINGw
Provider specific data types Information note If column length is 0 or > 4000 then: To use this data type with Qlik Replicate, you must enable the use of BLOBs for a specific task. During CDC or during Full Load when the Allow unlimited LOB size option is enabled, LOB data types are supported only in tables with a primary key or unique index.	If column length is < or = 4000: BYTES If column length is 0 or > 4000: BLOB

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here