Previous Topic Next topic Print topic


QUERY ODBC - Data Type Query

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  
Previous Topic Next topic Print topic