Data Types
Kofax Capture supports 11 ODBC-compliant data types for your field types, as shown in the Data Types table.
You specify the data type for a new field type on the Create Field Types window.
You edit the data type for an existing field type on the Field Type Properties window.
Data Type |
Description |
---|---|
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. |