Installation guide

mxODBC - Python ODBC Database Interface
Option Comment
Returns an integer value:
SQL.TRUE - column is auto-increment
SQL.FALSE - column is not an auto-increment
column or not numeric
SQL.DESC_BASE_COLUMN_NAME Base column name of the result set column. If the
base column name cannot be determined, e.g. for
expressions, an empty string is returned.
Returns a string..
SQL.DESC_BASE_TABLE_NAME Base table name of the result set column. If the base
table name cannot be determined, e.g. for
expressions, an empty string is returned.
Returns a string..
SQL.DESC_DISPLAY_SIZE Returns the maximum number of characters
needed to display the column data.
Returns an integer.
SQL.DESC_LENGTH Returns the maximum length of the column data in
characters.
Returns an integer.
SQL.DESC_OCTET_LENGTH Returns the maximum length of the column data in
bytes.
Returns an integer.
SQL.DESC_PRECISION Returns the precision of a numeric column.
For date/time columns, this returns the precision of
the seconds fraction, if applicable.
Returns an integer.
SQL.DESC_SCALE Returns the scale of a numeric column.
Returns an integer.
SQL.DESC_TABLE_NAME Table name of the table containing the result set
column. If the table name cannot be determined,
e.g. for expressions, an empty string is returned.
Returns a string..
108