skip to main content
Welcome to the Progress DataDirect Autonomous REST Connector for ODBC : Data Types
  

Try DataDirect Drivers Now

Data Types

The following table lists the REST API data types supported by the driver and how they are mapped to ODBC data types.
Table 5. REST API Data Types
REST API Data Type
ODBC Data Type
BigInt
SQL_BIGINT
Binary
SQL_BINARY
Bit
SQL_BIT
Boolean
SQL_BIT
Char
SQL_CHAR
Date
SQL_TYPE_DATE
Decimal
SQL_DECIMAL
Double
SQL_DOUBLE
Float
SQL_FLOAT
GUID
SQL_GUID
Integer
SQL_INTEGER
JSON
SQL_VARCHAR
LongVarBinary
SQL_LONGVARBINARY
LongVarChar
SQL_LONGVARCHAR
NVarChar
SQL_UNICODE_VARCHAR
SmallInt
SQL_SMALLINT
Time
SQL_TYPE_TIME
Timestamp
SQL_TYPE_TIMESTAMP
TinyInt
SQL_TINYINT
VarBinary
SQL_VARBINARY
VarChar
SQL_VARCHAR