Installation guide

mxODBC - Python ODBC Database Interface
Column Name Column Datatype Comment
COLUMN_NAME VARCHAR(128) not
NULL
Name of the column of the specified table,
view, alias, or synonym.
DATA_TYPE SMALLINT not NULL SQL data type of column identified by
COLUMN_NAME.
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() calls. This
length does not include any null-terminator.
For exact numeric data types, the length
accounts for the decimal and the sign.
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.
For numeric data types, the database can
return a NUM_PREC_RADIX of either 10 or
2.
NULLABLE SMALLINT not NULL SQL.NO_NULLS if the column does not
116