ODBC/MX Driver for Windows Manual (SQL/MX 3.x)

ODBC/MX Conformance
HP NonStop ODBC/MX Driver for Windows—640329-001
5-11
ODBC Data Types
FLOAT(p)FLOAT(p)FLOAT(p)Yes
DOUBLE PRECISION DOUBLE PRECISION DOUBLE
PRECISION
Yes
BIT Not supported Not supported No
TINYINT Not supported Not supported No
TINYINT UNSIGNED Not supported Not supported No
BIGINT LARGEINT LARGEINT Yes
BINARY(n) Not supported Not supported No
VARBINARY(n) Not supported Not supported No
LONG VARBINARY Not supported Not supported No
DATE DATE DATE Yes
TIME(p)TIMETIMEYes
TIMESTAMP TIMESTAMP TIMESTAMP Yes
INTERVAL MONTH(p) INTERVAL MONTH(p)Yes
INTERVAL YEAR(p) INTERVAL YEAR(p)Yes
INTERVAL YEAR(p) TO
MONTH
INTERVAL YEAR(p) TO
MONTH
Yes
INTERVAL DAY(p) INTERVAL DAY(p)Yes
INTERVAL HOUR(p) INTERVAL HOUR(p)Yes
INTERVAL MINUTE(p) INTERVAL MINUTE(p)Yes
INTERVAL SECOND(p) INTERVAL SECOND(p)Yes
INTERVAL DAY(p) TO
HOUR
INTERVAL DAY(p) TO
HOUR
Yes
INTERVAL DAY(p) TO
MINUTE
INTERVAL DAY(p) TO
MINUTE
Yes
INTERVAL DAY(p) TO
SECOND
INTERVAL DAY(p) TO
SECOND
Yes
INTERVAL
HOUR(p) TO MINUTE
INTERVAL
HOUR(p) TO MINUTE
Yes
Table 5-15. ODBC Data Types (page 2 of 3)
ODBC
Data Type
SQL/MX
Data Type
SQL/MP
Data Type
Supported by
ODBC/MX