ddbicon.pngLength


Define the internal (i.e., stored) size of the column, based on the data type. A negative length causes the absolute value of the length to be imposed on columns using this typedef. (Negative lengths are not recommended.)

 

Data Type

Length

Character String

Up to 32,767 bytes.

Numeric

Up to 32,767 bytes.

Integer

1, 2, 3, or 4 bytes.

Unsigned integer

1, 2, 3, or 4 bytes.

IEEE float

N/A (always 8 bytes).

BCD float

N/A (always 8 bytes).

Business math

N/A (always 8 bytes).

C float

N/A (always 4 bytes).

C double

N/A (always 8 bytes).