The results set for a data type query is:
TYPE_NAME | VARCHAR(128) NOT NULL | Driver dependent name for the column's data type |
DATA_TYPE | SMALLINT NOT NULL | See odbcext.cpy and odbc.cpy for constants representing the ODBC data type codes. |
PRECISION | INTEGER | Maximum precision for columns of this type. |
LITERAL_PREFIX | VARCHAR(128) | Character or characters required to prefix literal values for this type. |
LITERAL_SUFFIX | VARCHAR(128) | Character or characters required to suffix literal values for this type. |
CREATE_PARAMS | VARCHAR(128) | Parameters required when creating a column of this type, for example, 'precision,scale' for decimal types. |
NULLABLE | SMALLINT NOT NULL | |
CASE_SENSITIVE | SMALLINT NOT NULL | Specifies case sensitivity in comparisons for character data types. |
SEARCHABLE | SMALLINT NOT NULL | SQL_UNSEARCHABLE, SQL_LIKE_ONLY or SQL_ALL_EXCEPT_LIKE (these are defined in odbc_cpy). |
UNSIGNED_ATTRIBUTE | SMALLINT | Specifies if a numeric type is signed or unsigned. |
MONEY | SMALLINT NOT NULL | Specifies if a numeric type is a money data type. |
AUTO_INCREMENT | SMALLINT | Specifies if the data type is auto incrementing . |
LOCAL_TYPE_NAME | VARCHAR(128) | Localized version of the data type name. |
MINIMUM_SCALE | SMALLINT | |
MAXIMUM_SCALE | SMALLINT |