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

ODBC/MX Conformance
HP NonStop ODBC/MX Driver for Windows—527888-004
5-11
ODBC Data Types
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
INTERVAL HOUR(p) TO
SECOND(q)
INTERVAL HOUR(p) TO
SECOND(q)
Yes
INTERVAL MINUTE(p) TO
SECOND(
q)
INTERVAL MINUTE(p)
TO SECOND(q)
Yes
* The VARCHAR length can be up to 4059 for key-sequenced files or
4070 for entry-sequenced files.
Table 5-15. ODBC Data Types (page 2 of 2)
ODBC
Data Type
SQL/MX
Data Type
SQL/MP
Data Type
Supported by
ODBC/MX