Download SAP DB:ODBC 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
116
SMALLINT not NULL
SQL.NO_NULLS if the column does not