FAQ: Should I be concerned about precision and scale settings when creating a new field in my attribute table?
Should I be concerned about precision and scale settings when creating a new field in my attribute table?
When creating a new field, ArcCatalog may ask to specify a type, precision, and scale. Precision describes the number of digits that can be stored in the field, while scale describes the number of decimal places. The field type may change depending on the precision and scale values specified.
When creating a float, double, or integer field and specifying zero for precision and scale, the geodatabase attempts to create a binary type field, if the underlying database supports it. ArcGIS ignores precision and scale of binary type fields.
Depending on the precision and scale setting selected, ArcGIS may convert the field into another type. If creating a double field and specifying a precision of six or less, a float field is created. If creating a float field and specifying a precision greater than six, a double field is created. If specifying an integer field with a precision of ten or more, a double field is created.