Indicating Average Data Type Length

You can indicate the estimated average data type length for variable length data types. This average length value is then used instead of the maximum data type length when you estimate database size.

Note:

The average length value is particularly important for strings or long binary data types. A Binary Long OBject (BLOB) such as a picture can represent the largest portion of the space actually taken by a table.

Select Model > Tables .
The List of Tables is displayed.
Double-click a table name.
The Table Properties sheet opens to the General tab.
Click the Columns tab.
Double-click a column that uses a data type with variable length.
The Column Properties sheet opens to the General tab.
Click the Detail tab.
Type a value in the Average length box.
Click OK in each of the dialog boxes.