Understand schema structure schema-structure

This page lists how Adobe Campaign data types map to the data types of each database management system.

As part of the transition from Campaign v7 to v8, the Campaign Classic documentation set has been streamlined and reorganized. Common features are now available exclusively in the Campaign v8 documentation set. To learn more about schema structure, refer to the Campaign v8 documentation.

image

Mapping the types of Adobe Campaign/DBMS data mapping-the-types-of-adobe-campaign-dbms-data

The table below lists the mappings for the types of data generated by Adobe Campaign for the different database management systems.

Adobe Campaign
PosgreSQL
Oracle
String
VARCHAR(255)
VARCHAR2 (NVARCHAR2 if unicode)
Boolean
SMALLINT
NUMBER(3)
Byte
SMALLINT
NUMBER(3)
Short
SMALLINT
NUMBER(5)
Double
DOUBLE PRECISION
FLOAT
Long
INTEGER
NUMBER(10)
Int64
BIGINT
NUMBER(20)
Date
DATE
DATE
Time
TIME
FLOAT
Datetime
TIMESTAMPZ
DATE
Datetimenotz
TIMESTAMPZ
DATE
Timespan
DOUBLE PRECISION
FLOAT
Memo
TEXT
CLOB (NCLOB if Unicode)
Blob
BLOB
BLOB

Learn more

Browse the following links to learn more:

recommendation-more-help
campaign-classic-help