skip to main content
Data Types Supported : Supported Data Types : ODBC Client
 

ODBC Client

The following table lists the data types that the ODBC Client supports for the OpenAccess SDK SQL engine or a third-party SQL engine:
Table 41: Mapping OpenAccess SDK Data Types to ODBC Data Types
OpenAccess Server Data Type
ODBC Data Type
BIGINT
SQL_BIGINT
BINARY
SQL_BINARY
BIT
SQL_BIT
CHAR
SQL_CHAR
DATE
SQL_DATE
DOUBLE
SQL_DOUBLE
FLOAT
SQL_FLOAT
INTEGER
SQL_INTEGER
LONGVARBINARY
SQL_LONGVARBINARY
NUMERIC
SQL_VARCHAR
REAL
SQL_REAL
SMALLINT
SQL_SMALLINT
TIME
SQL_TIME
TIMESTAMP
SQL_TIMESTAMP
TINYINT
SQL_TINYINT
VARBINARY
SQL_VARBINARY
VARCHAR
SQL_VARCHAR
WCHAR
SQL_WCHAR
WLONGVARCHAR
SQL_WLONGVARCHAR
WVARCHAR
SQL_WVARCHAR