Installation guide

mxODBC - Python ODBC Database Interface
Column Name Column Datatype Comment
SQL.PARAM_OUTPUT: this parameter is an
output parameter.
SQL.RETURN_VALUE: the procedure column is
the return value of the procedure.
SQL.RESULT_COL: this parameter is actually a
column in the result set.
DATA_TYPE SMALLINT not NULL SQL data type of column.
TYPE_NAME VARCHAR(128) not
NULL
Character string representing the name of the
data type corresponding to DATA_TYPE.
COLUMN_SIZE INTEGER If the DATA_TYPE column value denotes a
character or binary string, then this column
contains the maximum length in characters for
the column.
For date, time, timestamp data types, this is the
total number of characters required to display
the value when converted to character.
For numeric data types, this is either the total
number of digits, or the total number of bits
allowed in the column, depending on the value in
the NUM_PREC_RADIX column in the result set.
BUFFER_LENGTH INTEGER The maximum number of bytes for the
associated C buffer to store data from this
column if SQL.C_DEFAULT were specified on the
SQLBindCol(), SQLGetData() and
SQLBindParameter() ODBC calls used
internally by mxODBC. This length does not
include any null-terminator. For exact numeric
data types, the length accounts for the decimal
and the sign.
Note: This column is of little value to Python
applications.
DECIMAL_DIGITS SMALLINT The scale of the column. NULL is returned for
data types where scale is not applicable.
NUM_PREC_
RADIX
SMALLINT Either 10 or 2 or NULL. If DATA_TYPE is an
approximate numeric data type, this column
contains the value 2, then the COLUMN_SIZE
column contains the number of bits allowed in
the column.
If DATA_TYPE is an exact numeric data type, this
column contains the value 10 and the
COLUMN_SIZE contains the number of decimal
digits allowed for the column.
126