Chapter 2: Catalog Stored Procedures

ODBC datatypes

Table 2-2 and Table 2-3 list the datatype code numbers and matching datatype names returned by sp_columns and sp_sproc_columnsin the “data_type” column. The source for the description is the Open Database Connectivity (ODBC) Application Programming Interface (API).

**Table 2-2: Code numbers for ODBC datatypes**
Datatype	Code #
char	1
decimal	3
double precision	8
float	6
integer	4
numeric	2
real	7
smallint	5
varchar	12

**Table 2-3: Code numbers for extended datatypes**
Datatype	Code #
bigint	-5
binary (bit datatype)	-2
bit	-7
date	9
java.lang.Object	1111
long varbinary	-4
long varchar	-1
time	10
timestamp	11
tinyint	-6
varbinary (bit-varying datatype)	-3

View this book as PDF