ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-13
Data Types
Supported DATETIME Formats
The NonStop ODBC Server supports the following DATETIME formats, which are a
subset of the Transact-SQL DATETIME formats:
IMAGE – –
INT x INTEGER
MONEY x DECIMAL
SMALLINT x SMALLINT
SYSNAME x VARCHAR (30)
TEXT x VARCHAR (The default is 512)
TINYINT x SMALLINT
USER_TYPE – –
VARBINARY – –
VARCHAR x VARCHAR
x Indicates a supported data type
– Indicates an unsupported data type
datetime
date
time
time date
mixed datetime
Table 4-4. Conversion of Transact-SQL Data Types to NonStop SQL/MP Data
Types
Transact-SQL
Data Type
NonStop ODBC
Server Support Corresponding NonStop SQL/MP Data Type