skip to main content
Supported data types : Oracle Service Cloud data types
 

Try DataDirect Cloud Now

Oracle Service Cloud data types

The following table lists the Oracle Service Cloud data types and their equivalents for JDBC and ODBC.
Table 15. Oracle Service Cloud data types
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)