|
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
|