User guide

The view model editor
62 Data Integration with Sybase Avaki Studio
Precision and scale. The meaning of the precision and scale fields for a column
depends on the column’s data type. Precision and scale are not applicable to all column
types. The table below gives the meaning of precision and scale for the Studio column
types to which they apply.
Types Precision Scale
BINARY,
LONGVARBINARY,
VARBINARY
The size of the column data
(in bytes)
Not applicable
CHAR,
LONGVARCHAR,
VARCHAR
The size of the column data
(in characters)
Not applicable
DECIMAL,
NUMERIC
The total number of digits in
the column data (includes
digits on both sides of the
decimal point)
The number of digits to the
right of the decimal point