I have some data in SQL Server 2016 which contains a field type of REAL, and I have no control over changing the underlying schema. This is not in an Enterprise Geodatabase, but is a simple table containing a geometry field.
This is how it looks via SQL Server Management Studio:
We can see this appears similar to a float:
o via a Query Layer, it looks like this:
Flows through as a float but I have lost the scale
Looking at the help - SQL Server data types supported in ArcGIS – suggests REAL field type is supported for view only (which is what I need).
However, I can't see where I can change any settings to ensure the full scale flows through.
Hoping this might be an easy one to solve and something basic I may have overlooked.