Defining the column type(s)

Each named column in the database has a corresponding item type under the Column type in the type tree with the same name. For example, if the DEMO.DEPARTMENT table in the database has three columns (DEPARTMENT_ID, LOCATION_ID, and NAME), the type tree will have three identically named items (subject to restrictions described in Special Characters in Type Names ) under the Column type.

Each item is defined according to the data type and length information returned to the database adapter by the database driver. For more information about the correspondence between database data types and item formats, see the specific adapter reference guides.

The minimum size of item types for columns in a delimited Row is 0 unless otherwise specified by the database driver. The minimum size of item types for columns in a fixed Row equals the maximum size.