Supported data types for user tables

Before you map user tables in Campaign, ensure that your tables use only the supported data types for each supported database. Data types that are not listed here are not supported.

A column of datatype DATE, DATETIME, or TIMESTAMP of a table, when mapped in an IBM® Campaign flowchart, appears as type TEXT with the format of the DATE, DATETIME, or TIMESTAMP stored in brackets, such as [DELIM_D_M_Y] or [DT_DELIM_D_M_Y]. Although its data type in table mapping in the flowchart shows as TEXT, the application knows the format and handles it accordingly. Do not map columns of these three data types or any of the date- or time-related data types as an Audience ID column to a TEXT audience level. Mapping the date-related column as TEXT audience level is not supported.

DB2®

Netezza®

char(n) [1]

nchar(n) [2]

nvarchar(n) [2]

varchar(n) [1]

[1] Not supported when used in the same table with nchar or nvarchar.

[2] Not supported when used in the same table with char or varchar.

Oracle

DATE

FLOAT (p)

NUMBER [ (p , s) ] [1]

TIMESTAMP

VARCHAR2(size BYTE)

[1] Precision is required for NUMBER unless you set the data source property Campaign > partitions > partition[n] > dataSources > [dataSourceName] > UseSQLToRetrieveSchema to TRUE. If you do not specify a precision and you do not set UseSQLToRetrieveSchema to TRUE, Campaign assumes it can store the values in a data type that preserves 15 digits of precision. This can be problematic for fields that hold values whose precision exceeds 15 digits because precision will be lost when the value is brought into Campaign.

char(n) [1]

nchar [2]

nvarchar(n) [2, 3]