|
Oracle Service Cloud data type
|
Documented Name
|
JDBC data type
|
ODBC data type
|
|
BASE_64_BINARY
|
base64binary
|
LONGVARBINARY
|
SQL_LONGVARBINARY(-4)
|
|
BOOLEAN
|
boolean
|
BOOLEAN
|
SQL_BIT(-7)
|
|
DATE
|
date
|
DATE
|
SQL_TYPE_DATE(91)
|
|
DATETIME
|
datetime
|
TIMESTAMP
|
SQL_TYPE_TIMESTAMP(93)
|
|
DECIMAL
|
double
|
DOUBLE
|
SQL_DOUBLE(8)
|
|
ID
|
ID
|
BIGINT
|
SQL_BIGINT(-5)
|
|
INTEGER
|
int
|
INTEGER
|
SQL_INTEGER(4)
|
|
LONG
|
long
|
BIGINT
|
SQL_BIGINT(-5)
|
|
LONGTEXT
|
longText
|
LONGVARCHAR
|
SQL_WLONGVARCHAR(-10) or SQL_LONGVARCHAR (-1)
|
|
STRING
|
string
|
VARCHAR
|
SQL_VARCHAR(12)
|