Background documentation-3020: Invalid length for this data type Locate this document in the navigation structure

 

Explanation

The specified length is not permitted for the data type.

User Response

  1. Choose a value between 1 and 254 (SQL mode ANSI) or between 1 and 8000 (SQL mode INTERNAL and ORACLE or 1 and 4000 (SQL mode DB2) for the length attribute of a CHAR-type column.

  2. Choose a value between 1 and 38 for the precision of a FIXED- or FLOAT-type column.