Oracle Service Cloud Data Type
|
Documented Name
|
ODBC Data Type
|
BASE_64_BINARY
|
base64binary
|
SQL_LONGVARBINARY(-4)
|
BOOLEAN
|
boolean
|
SQL_BIT(-7)
|
DATE
|
date
|
SQL_TYPE_DATE(91)
|
DATETIME
|
datetime
|
SQL_TYPE_TIMESTAMP(93)
|
DECIMAL
|
double
|
SQL_DOUBLE(8)
|
ID
|
ID
|
SQL_BIGINT(-5)
|
INTEGER
|
int
|
SQL_INTEGER(4)
|
LONG
|
long
|
SQL_BIGINT(-5)
|
LONGTEXT
|
longText
|
SQL_LONGVARCHAR(-10)
|
STRING
|
string
|
SQL_VARCHAR(12)
|