String Data Types String data types are normally used to store names, addresses, descriptions or any value that contains letters and numbers including binary data, like image or audio files. To use this data type with Qlik Replicate, you must enable the use of BLOBs for a specific task.īLOB data types are supported only in tables that include a primary key. The data types supported by the Microsoft SQL Server can be grouped into three main categories: string, numeric and date/time data types. You can use the float or double data types for decimals with a precision greater than 38.

To use this data type with Qlik Replicate, you must enable the use of NCLOBs for a specific task.ĭuring CDC, NCLOB data types are supported only in tables that include a primary key. DECIMAL (M,D) decimal (p,s) The maximum precision is 38, while the default is 18. LOB columns for Amazon RDS for SQL Server tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Amazon RDS for SQL Server.ĭuring CDC, CLOB data types are supported only in tables that include a primary key.įor more information, see LOB support in Task Settings/ Metadata. To use this data type with Qlik Replicate, you must enable the use of CLOBs for a specific task. SQL server and Qlik Replicate data types Amazon RDS for SQL server data types

Sql server data types