Installation guide

mxODBC - Python ODBC Database Interface
Column Name Column Datatype Comment
SQL.LIKE_ONLY: if the data type can be
used in a WHERE clause only with the LIKE
predicate.
SQL.ALL_EXCEPT_LIKE: if the data type can
be used in a WHERE clause with all
comparison operators except LIKE.
SQL.SEARCHABLE: if the data type can be
used in a WHERE clause with any
comparison operator.
UNSIGNED_ATTRIBUTE SMALLINT Indicates where the data type is unsigned.
The valid values are: SQL.TRUE, SQL.FALSE
or NULL. A NULL indicator is returned if
this attribute is not applicable to the data
type.
FIXED_PREC_SCALE SMALLINT not NULL Contains the value SQL.TRUE if the data
type is exact numeric and always has the
same precision and scale; otherwise, it
contains SQL.FALSE.
AUTO_INCREMENT SMALLINT Contains SQL.TRUE if a column of this data
type is automatically set to a unique value
when a row is inserted; otherwise, contains
SQL.FALSE.
LOCAL_TYPE_NAME VARCHAR(128) This column contains any localized (native
language) name for the data type that is
different from the regular name of the data
type. If there is no localized name, this
column is NULL.
This column is intended for display only.
The character set of the string is locale-
dependent and is typically the default
character set of the database.
MINIMUM_SCALE INTEGER The minimum scale of the SQL data type. If
a data type has a fixed scale, the
MINIMUM_SCALE and MAXIMUM_SCALE
columns both contain the same value.
NULL is returned where scale is not
applicable.
MAXIMUM_SCALE INTEGER The maximum scale of the SQL data type.
NULL is returned where scale is not
applicable. If the maximum scale is not
defined separately in the database, but is
defined instead to be the same as the
maximum length of the column, then this
column contains the same value as the
COLUMN_SIZE column.
122