ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-10
Data Types
ODBC describes the minimum limit that must be met by any conformant ODBC
implementation, and implements a call interface by which an application can detect the
actual implementation-defined limit. The NonStop ODBC Server satisfies each of the
ODBC core-level minimums, and in most cases exceeds those minimums.
For more information, see the following documents:
Retrieving and Manipulating NonStop SQL/MP Data and
Objects
When you access data and objects, the NonStop ODBC Server converts NonStop
SQL/MP data types and values to CORE SQL data types and values. Table 3-4
summarizes the NonStop SQL/MP data types, corresponding CORE SQL data types,
and conversion information.
For Information About See
CORE SQL data types Microsoft ODBC 2.1 Programmer’s Reference and SDK
Guide
NonStop SQL/MP data types NonStop SQL/MP Reference Manual
Table 3-4. Conversion of NonStop SQL/MP Data Types to CORE SQL Data
Types (page 1 of 2)
NonStop SQL/MP Data Type Corresponding CORE SQL Data Type
CHAR CHAR
DATE DATE
DATETIME qualifier DATE
TIME
TIMESTAMP
DECIMAL DECIMAL
DOUBLE PRECISION DOUBLE PRECISION
FLOAT FLOAT
INTEGER INTEGER
INTEGER unsigned BIGINT
INTERVAL CHAR
LARGEINT BIGINT
NUMERIC NUMERIC
REAL REAL
SMALLINT SMALLINT
SMALLINT unsigned INTEGER
TIME TIME