CLI Reference Guide

Application Development ODBCLink/SE Reference Manual
ODBCLink/SE
34 ©M.B. Foster Associates Limited 1995-2000
Supported Data Types
The following is a table of correspondence between HP data types and ODBC data types.
ALLBASE/SQL or Image or
IMAGE/SQL Data Type
ODBC Data Type Comments
CHAR, max length <255 SQL_CHAR
CHAR, max length >=255 SQL_LONGVARCHAR
VARCHAR, max length <255 SQL_VARCHAR
VARCHAR, max length >=255 SQL_LONGVARCHAR
BINARY, length <256 SQL_BINARY
BINARY, length >=256 SQL_LONGVARBINA
RY
VARBINARY <256 SQL_VARBINARY
VARBINARY >=256 SQL-
LONGVARBINARY
LONG BINARY SQL_LONGVARBINA
RY
LONG VARBINARY SQL_LONGVARBINA
RY
INTEGER (32-bit) SQL_INTEGER
DECIMAL (Internal
representation is packed decimal)
SQL_DECIMAL Character representation with leading sign
and decimal point
Image Zoned (Z) SQL_DECIMAL Converted by Image/SQL
Image Packed (P) SQL_DECIMAL Converted by Image/SQL
Image I3 (48-bit integer) SQL_DECIMAL Converted by Image/SQL
Image I4 (64-bit integer) SQL_DECIMAL Converted by Image/SQL
FLOAT(24) or REAL or Image
E2
SQL_REAL
FLOAT(53) or DOUBLE
PRECISION or Image E4
SQL_DOUBLE
Image R2 (non-IEEE float) SQL_REAL Converted by Image/SQL
Image R4 (non-IEEE float) SQL_DOUBLE Converted by Image/SQL