Data Types


A variety of data types are supported for the Verity field types. Data types define the type of data you want to store in a Verity field. The Verity field types define the scope of the field, meaning whether the field information is the same across the collection or just document-by-document.

The Verity field types are described in the following section, "Field Types."

The following table lists valid data types.

Data Type
Description
text
ASCII characters.
signed-integer
A range of integers (from negative 2 billion to positive 2 billion) stored in binary format.
unsigned-integer
A range of integers (from 0 to 4 billion) stored in binary format.
date
An internal date format that stores dates (and times) for the range of years: 1904 to 2037.

If field-level searches are to be conducted over a field containing a date, the date field must be defined as a fixed-width or constant field that is assigned a data type called date or xdate. More than one date field can be defined for a collection.

xdate
An internal date format that stores dates (and times) for an extended range of years than the date format: 1000 AD to 3000 AD, with a one minute resolution. Due to a calendar adjustment in the 16th century, the day of the week may be inaccurate for dates before the adjustment.
float
Floating point number stored in IEEE 754 format.

Data Tables

Field types and data types and variables are stored in one or more data tables. The number of data tables used for a collection depends upon the field types to be included. In some cases, isolating a field definition in its own data table results in improved system performance. More information about the various field and data types and issues surrounding system performance are described in the sections that follow.

Every data table in a collection must contain at least one physical field. That is, at least one field in every data table must be defined with a field type other than constant.





Copyright © 2002, Verity, Inc. All rights reserved.