skip to main content
Supported data types : HubSpot data types
 

Try DataDirect Cloud Now

HubSpot data types

The following table lists the data types supported for the HubSpot data store, and how the HubSpot Web Service API data types map to the ODBC and JDBC data types.
Of the available data types exposed by the web service, as of this writing, HubSpot uses the following subset but makes available a larger set to support future web service API changes.
Table 6. HubSpot data types for remote tables
Native type
ODBC type
JDBC data type
STRING
SQL_WVARCHAR or SQL_VARCHAR
VARCHAR
BOOL
SQL_BIT
BIT
NUMBER
SQL_INTEGER
INTEGER
DATETIME
SQL_TIMESTAMP
TIMESTAMP
ENUMERATION
BIG_INT
BIGINT
DEFAULT
SQL_WVARCHAR
VARCHAR