ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-9
Data Types
Creating Objects and Data
When you create objects and data, you specify CORE SQL data types and values. The
NonStop ODBC Server handles the data type or value in one of two ways:
•
Fully supports it—the data type or value is processed as you input it.
•
Converts it—the data type or value is converted to a corresponding NonStop
SQL/MP data type or value.
Table 3-3 summarizes the CORE SQL data types, the corresponding NonStop SQL/MP
data types, and the conversion information.
The NonStop ODBC Server supports the ODBC Extended SQL data types as well as
those provided at the Core level.
Table 3-3. Conversion of CORE SQL Data Types to NonStop SQL/MP Data Types
CORE SQL Data Type
NonStop ODBC
Server Support
Corresponding NonStop SQL/MP Data
Type
CORE SQL Data Type
CHAR x CHAR
DECIMAL x DECIMAL
DOUBLE PRECISION x DOUBLE PRECISION
FLOAT x FLOAT
INTEGER x INTEGER
NUMERIC x NUMERIC
REAL x REAL
SMALLINT x SMALLINT
VARCHAR x VARCHAR
Extended SQL Data Types
BIGINT x LARGEINT
BINARY x CHAR
BIT x SMALLINT
DATE x DATETIME year to day
LONG VARBINARY x VARCHAR
LONG VARCHAR x VARCHAR
TIME x DATETIME hour to second
TIMESTAMP x DATETIME hour to fraction(6)
TINYINT x SMALLINT
VARBINARY x VARCHAR
x Indicates a supported data type