ODBC Server Reference Manual

Summary of Support for ODBC Features
HP NonStop ODBC Server Reference Manual—429151-002
A-2
Data Types
Data Types
The NonStop ODBC Server supports all ODBC data types, at both the Core level and
the Extended level. When you create objects and data, however, the NonStop ODBC
Server maps the data to a HP NonStop SQL/MP data type.
Table A-1 summarizes the ODBC data types and the corresponding NonStop SQL/MP
data types.
Table A-1. Conversion of ODBC Data Types to NonStop SQL/MP Data Types
ODBC Data Type ODBC Language Level
Corresponding NonStop SQL/MP
Data Type
BIGINT E LARGEINT
BINARY E CHAR
BIT E SMALLINT
CHAR C CHAR
DATE E DATETIME year to day
DECIMAL C DECIMAL
DOUBLE PRECISION C DOUBLE PRECISION
FLOAT C FLOAT
INTEGER C INTEGER
NUMERIC C NUMERIC
LONG VARBINARY E VARCHAR
LONG VARCHAR E VARCHAR
REAL C REAL
SMALLINT C SMALLINT
TIME E DATETIME hour to second
TIMESTAMP E DATETIME hour to fraction(6)
TINYINT E SMALLINT
VARBINARY E VARCHAR
VARCHAR C VARCHAR
C Indicates a Core-level data type
E Indicates an Extended-level data type