skip to main content
Querying data stores with SQL : Supported data types : Autonomous REST Connector data types
  

Try Now

Autonomous REST Connector data types

The following table shows supported REST API data types and how they are mapped to the standard data types for ODBC and JDBC.
Table 153. REST API Data Types
REST API Data Type
JDBC Data Type
ODBC Data Type
BigInt
BIGINT
SQL_BIGINT
Binary
BINARY
SQL_BINARY
Bit
BIT
SQL_BIT
Boolean
BOOLEAN
SQL_BIT
Char
CHAR
SQL_CHAR
Date
DATE
SQL_TYPE_DATE
Decimal
DECIMAL
SQL_DECIMAL
Double
DOUBLE
SQL_DOUBLE
Float
DATETIME
SQL_FLOAT
GUID
GUID
SQL_GUID
Integer
INTEGER
SQL_INTEGER
JSON
JSON
SQL_VARCHAR
LongVarBinary
LONGVARBINARY
SQL_LONGVARBINARY
LongVarChar
LONGVARCHAR
SQL_LONGVARCHAR
NVarChar
NVARCHAR
SQL_UNICODE_VARCHAR
SmallInt
SMALLINT
SQL_SMALLINT
Time
TIME
SQL_TYPE_TIME
TimeWithTimeZone
TIMEWITHTIMEZONE
SQL_TYPE_TIME
Timestamp
TIMESTAMP
SQL_TYPE_TIMESTAMP
TimestampWithTimeZone
TIMESTAMPWITHTIMEZONE
SQL_TYPE_TIMESTAMP
TinyInt
TINYINT
SQL_TINYINT
VarBinary
VARBINARY
SQL_VARBINARY
VarChar
VARCHAR
SQL_VARCHAR
VarCharIgnoreCase
VARCHARIGNORECASE
SQL_VARCHAR