CHAR

Variable-length character string. You can specify up to 25,000 characters.

DATE

Date string. Note that validation of date fields is sometimes dependent on the regional date format settings specified from Windows Control Panel.

DECIMAL

Signed, numeric value with the number of numeric digits greater than or equal to 1, and less than or equal to 15, and the number of decimal places greater than 0, but less than or equal to the number of numeric digits.

DOUBLE

Signed, floating-point value with the number of digits equal to 15.

FLOAT

Signed, floating-point value with the number of digits equal to 15.

INTEGER

Numeric value with the number of numeric digits equal to 10, and the number of decimal places equal to 0. The range is -2,147,483,648 to 2,147,483,647.

NUMERIC

Signed, numeric value with the number of numeric digits greater than or equal to 1 and less than or equal to 15, and the number of decimal places greater than 0 but less than or equal to the number of numeric digits.

REAL

Signed, single-precision value with the number of numeric digits equal to 7.

SMALLINT

Numeric value with the number of numeric digits equal to 5, and the number of decimal places equal to 0. The range is -32,768 to 32,767.

TIME

Time string.

VARCHAR

Variable length character string. When defining a field type as a CHAR or VARCHAR data type, you must specify the maximum number of characters for the field type. For example, if you specify 25 as the number of characters, data for that field can be up to 25 characters in length. You can specify up to 25,000 characters. However, the maximum length of known values for field types based on CHAR or VARCHAR is 254 characters.