|
Oracle Marketing Cloud type
|
JDBC data type
|
ODBC type
|
|
ARRAY
|
VARCHAR
|
SQL_WVARCHAR(-9) or SQL_WVARCHAR(12)
|
|
BOOLEAN
|
BOOLEAN
|
SQL_BIT (-7)
|
|
DATETIME
|
TIMESTAMP
|
SQL_TYPE_TIMESTAMP(93)
|
|
DECIMAL
|
DECIMAL
|
SQL_DECIMAL(3)
|
|
DURATION
|
VARCHAR
|
SQL_WVARCHAR(-9) or SQL_WVARCHAR(12)
|
|
INTEGER
|
INTEGER
|
SQL_INTEGER (-4)
|
|
LARGETEXT
|
LONGVARCHAR
|
SQL_WLONGVARCHAR(-10) or SQL_LONGVARCHAR(-1)
|
|
LONG
|
BIGINT
|
BIGINT (-5)
|
|
TEXT
|
VARCHAR
|
SQL_WVARCHAR(-9) or SQL_WVARCHAR(12)
|
|
URL
|
VARCHAR
|
SQL_WVARCHAR(-9) or SQL_WVARCHAR(12)
|