Supported data types

The following table shows the SingleStore database 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 endpoint you are using.

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

Supported data types
Qlik Replicate Data Types	SingleStore Data Types
BOOL	BOOL
BYTES	If length is => 1 and =< 8095, then: VARBINARY (Length) If length is => 8096 and =< 65535, then: BLOB If length is => 65536 and =< 16777215, then: MEDIUMBLOB If length is => 16777216 and =< 2147483647, then: LONGBLOB
DATE	DATE
TIME	TIME
DATETIME	If scale is => 0 and =< 6, then: DECIMAL (p,s) If scale is => 7 and =< 12, then: VARCHAR (37)
INT1	TINYINT
INT2	SMALLINT
INT4	INTEGER
INT8	BIGINT
NUMERIC	If scale is => 0 and =< 30, then: DECIMAL (p,s) If scale is => 31 and =< 100, then: VARCHAR (45)
REAL4	FLOAT
REAL8	DOUBLE
STRING	If length is => 1 and =< 8095, then: VARCHAR (Length) If length is => 8096 and =< 65535, then: TEXT If length is => 65536 and =< 16777215, then: MEDIUMTEXT If length is => 16777216 and =< 2147483647, then: LONGTEXT
UINT1	UNSIGNED TINYINT
UINT2	UNSIGNED SMALLINT
UINT4	UNSIGNED INTEGER
UINT8	UNSIGNED BIGINT
WSTRING	If length is => 1 and =< 8095, then: VARCHAR (Length) If length is => 8096 and =< 65535, then: TEXT If length is => 65536 and =< 16777215, then: MEDIUMTEXT If length is => 16777216 and =< 2147483647, then: LONGTEXT
BLOB	When the Allow unlimited LOB size option is enabled: LONGBLOB When the Limit LOB size to option is enabled: If the specified value i is 63 KB or smaller, then: BLOB If the specified value is 64 KB or larger, then: LONGBLOB For information on limiting LOB size, see Target metadata.
NCLOB	When the Allow unlimited LOB size option is enabled: TEXT When the Limit LOB size to option is enabled: If the specified value is 63 KB or smaller, then: TEXT If the specified value is 64 KB or larger, then: LONGTEXT For information on limiting LOB size, see Target metadata.
CLOB	When the Allow unlimited LOB size option is enabled: TEXT CHARACTER SET UTF-16 When the Limit LOB size to option is enabled: If the specified value is 63 KB or smaller, then: TEXT CHARACTER SET UTF-16 If the specified value is 64 KB or larger, then: LONGTEXT CHARACTER SET UTF-16 For information on limiting LOB size, see Target metadata.

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