Neoview ODBC Drivers Manual (R2.5)

Table 7-15 ODBC Data Types
Supported by HP ODBCSQL Data TypeODBC Data Type
Yes
CHAR(n)CHAR(n)
Yes
VARCHAR(n) *VARCHAR(n)
Yes
DECIMAL(p,s)DECIMAL(p,s)
Yes
NUMERIC(p,s)NUMERIC(p,s)**
YesSMALLINTSMALLINT
YesINTEGERINTEGER
YesREALREAL
Yes
FLOAT(p)FLOAT(p)
YesDOUBLE PRECISIONDOUBLE PRECISION
NoNot supportedBIT
NoNot supportedTINYINT
NoNot supportedTINYINT UNSIGNED
YesLARGEINTBIGINT
NoNot supportedBINARY(n)
NoNot supported
VARBINARY(n)
NoNot supportedLONG VARBINARY
YesDATEDATE
YesTIME
TIME(p)
YesTIMESTAMPTIMESTAMP
Yes
INTERVAL MONTH(p)INTERVAL MONTH(p)
Yes
INTERVAL YEAR(p)INTERVAL YEAR(p)
Yes
INTERVAL YEAR(p) TO MONTHINTERVAL 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 HOURINTERVAL DAY(p) TO HOUR
Yes
INTERVAL DAY(p) TO MINUTEINTERVAL DAY(p) TO MINUTE
Yes
INTERVAL DAY(p) TO SECONDINTERVAL DAY(p) TO SECOND
Yes
INTERVAL HOUR(p) TO MINUTEINTERVAL 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 VARCHAR length can be up to 4059 for key-sequenced files or 4070 for entry-sequenced files.
** The numeric precision can be up to 128. If the precision is greater than 18 for signed and greater than 9 for unsigned
numeric data type, SQLBindParameter while inserting the data and SQLBindCol while selecting the data with
SQL_C_CHAR must be used.
SQL Conformance Level 71