Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


TYPE_INFO


Records information about data types supported.

Column name
Data type
Description

DATA_TYPE

SMALLINT

Identification number for data type.

TYPE_NAME

CHAR(30)

Name of data type.

COLUMN_SIZE

INTEGER

Length of data type name.

LITERAL_PREFIX

CHAR(30)

Optional prefix for a literal of this type.

LITERAL_SUFFIX

CHAR(30)

Optional suffix for a literal of this type.

CREATE_PARAMS

CHAR(30)

A description of how to specify length attributes for the data type.

NULLABLE

SMALLINT

One of:
1 = A not null constraint can be used with this type in a domain or column definition
0 = A not null constraint can not be used with this type in a domain or column definition.

CASE_SENSITIVE

SMALLINT

One of:
1 = The data type name is case sensitive
0 = The data type name is not case sensitive.

SEARCHABLE

SMALLINT

One of:
3 = The data type can be used with any comparison operator
2 = The data type can be used with any comparison operator except like
1 = The data type can only be used with the LIKE operator
0 = The data type can not be used with any comparison operator.

UNSIGNED_ATTRIBUTE

SMALLINT

One of:
1 = The data type is unsigned
0 = The data type is signed
The value is null if the data type is non-numeric.

FIXED_PREC_SCALE

SMALLINT

One of:
1 = The data type has a determined precision and scale
0 = The data type does not have a determined precision and scale.

AUTO_UNIQUE_VALUE

SMALLINT

One of:
1 = The data type will generate unique values
0 = The data type will not generate unique values.

LOCAL_TYPE_NAME

CHAR(30)

Local name for data type.

MINIMUM_SCALE

SMALLINT

Minimum value for scale for a numeric data type.

MAXIMUM_SCALE

SMALLINT

Maximum value for scale for a numeric data type.

SQL_DATA_TYPE

SMALLINT

A numeric value representing the data type.

SQL_DATETIME_SUB

SMALLINT

Sub type for an interval data type.

NUM_PREC_RADIX

SMALLINT

Radix for numeric data type.

INTERVAL_PRECISION

SMALLINT

Precision for an interval data type.

PRECISION

INTEGER

Precision for data type.

INTERNAL_LEN_DIFF

SMALLINT

Internal length difference.

INTERNAL_TYPENAME

CHAR(30)

Internal type name.

INTERNAL_VERSION

SMALLINT

Internal version number.

INTERNAL_TYPEORDER

SMALLINT

Internal type ordering number.

Primary key: DATA_TYPE, TYPE_NAME



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL System Management Handbook TOC PREV NEXT INDEX