Unsigned data types – HP Integrity NonStop H-Series User Manual
Page 39
Table 6 ODBC Data Types (continued)
Supported by the driver?
SQL/MP data Type
SQL/MX data Type
ODBC data type
No
Not supported
Not supported
TINYINT UNSIGNED
Yes
LARGEINT
LARGEINT
BIGINT
No
Not supported
Not supported
BINARY(n)
No
Not supported
Not supported
VARBINARY(n)
No
Not supported
Not supported
LONG VARBINARY
Yes
DATE
DATE
DATE
Yes
TIME
TIME
TIME(p)
Yes
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)
* The default size allocated for VARCHAR length is 4K (4096). The VARCHAR length can be up
to 4059 for key-sequenced files or 4070 for entry-sequenced files.
** Starting with SQL/MX Release 3.0, the precision of the NUMERIC data type is extended to
128 digits. If the precision is greater than 18 for signed and greater than 9 for the unsigned
numeric data type, use the SQLBindParameter API to insert the data and the SQLBindCol API
to select the data with the SQL_C_CHAR data type.
Unsigned data types
The behavior of unsigned data types is determined by the ODBC version and the
SQL_ATTR_MSACCESS_VERSION
flag setting.
explains the behavior of unsigned data
types.
Unsigned data types
39