SQLDA Data Types

SQLDA Data Type	Value	Description
SQL_TYP_CHAR	1	Character string
SQL_TYP_NUMERIC	2	Numeric
SQL_TYP_DECIMAL	3	Packed-Decimal
SQL_TYP_INTEGER	4	Integer (4 byte)
SQL_TYP_SMALLINT	5	Small Integer (2 byte)
SQL_TYP_FLOAT	6	Floating Point
SQL_TYP_LARGEINT	9	Large Integer (8 byte)
SQL_TYP_VARCHAR	12	Variable Length Character
SQL_TYP_NUMERIC_LD	20	Numeric Signed Leading
SQL_TYP_NUMERIC_TR	21	Numeric Signed Trailing
SQL_TYP_NUMERIC_SLD	22	Numeric Signed Leading Separate
SQL_TYP_NUMERIC_STR	23	Numeric Signed Trailing Separate
SQL_TYP_NUMERIC_BINARY	24	Numeric Binary (Little Endian)
SQL_TYP_NUMERIC_BIN_BE	25	Numeric Binary (Big Endian)
SQL_TYP_NCHAR	-1	Nullable Character string
SQL_TYP_NNUMERIC	-2	Nullable Numeric
SQL_TYP_NDECIMAL	-3	Nullable Packed-Decimal
SQL_TYP_NINTEGER	-4	Nullable Integer (4 byte)
SQL_TYP_NSMALLINT	-5	Nullable Small Integer (2 byte)
SQL_TYP_NFLOAT	-6	Nullable Floating-Point
SQL_TYP_NLARGEINT	-9	Nullable Large Integer (8 byte)
SQL_TYP_NVARCHAR	-12	Nullable Variable Length Character
SQL_TYP_NNUMERIC_LD	-20	Nullable Numeric Signed Leading
SQL_TYP_NNUMERIC_TR	-21	Nullable Numeric Signed Trailing
SQL_TYP_NNUMERIC_SLD	-22	Nullable Numeric Signed Leading Separate
SQL_TYP_NNUMERIC_STR	-23	Nullable Numeric Signed Trailing
SQL_TYP_NNUMERIC_BINARY	-24	Nullable Numeric Signed Leading Separate
SQL_TYP_NNUMERIC_BIN_BE	-25	Nullable Numeric Signed Trailing Separate
SQL_TYP_BINARY	-51	Nullable Numeric Binary (Little Endian)
SQL_TYP_NBINARY	-52	Nullable Numeric Binary (Big Endian)
SQL_TYP_NATDATE	-53	Binary
SQL_TYP_NNATDATE	-54	Nullable BINARY
SQL_TYP_NATTIME	-55	NATURAL DATE
SQL_TYP_NNATTIME	-56	Nullable NATURAL TIME
SQL_TYP_SQLDA	-57	SQLDA
SQL_TYP_NATTIMESTAMP	-58	NATURAL TIMESTAMP
SQL_TYP_NNATTIMESTAMP	-59	Nullable NATURAL TIMESTAMP
SQL_TYP_SQLBIT	-60	BIT
SQL_TYP_NSQLBIT	-61	Nullable BIT