Neoview ODBC Drivers Manual (R2.4)

Table 5-15 ODBC Data Types
Supported by HP ODBCSQL Data TypeODBC Data Type
Yes
CHAR(n)CHAR(n)
Yes
VARCHAR(n) *VARCHAR(n)
Yes
VARCHAR(n)
LONGVARCHAR
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)
SQL Conformance Level 53