laptop and a wrench

Bug

Adding a field of the float data type without further specification in an enterprise geodatabase creates a field of the double data type.

ArcGIS Pro
Bug ID Number BUG-000159745
SubmittedJuly 8, 2023
Last ModifiedNovember 16, 2025
Applies toArcGIS Pro
Version found3.1.2
Operating SystemWindows OS
Operating System Version11.0 64 bit
StatusAs Designed

Additional Information

Please refer to https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/data-types-oracle.htm and https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/data-types-sqlserver.htm for information on how, in ArcGIS, the float and double data types are stored in enterprise geodatabases on Oracle or SQL Server. The difference between these types at the DBMS level is entirely based on the values of precision & scale. The data type itself is the same number for Oracle and numeric for SQL Server. If the value for precision & scale is not provided, it defaults to the highest values (38, 8) and is then recognized as an ArcGIS double data type. If fields are added via the Fields designer in ArcGIS Pro, a float cannot have a precision greater than 6, and a double cannot be created with a precision less than 7.

Steps to Reproduce

Bug ID: BUG-000159745

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options