VERIFIED SOLUTION i
X

How to find out which data format is used within Confirm for Eastings/Northings

UPDATED: September 28, 2017


Which data format is used within Confirm for Eastings/Northings?

Oracle

The answer is NUMBER(10,2) so precision = 10, scale = 2. A number data type is very versatile. In the Oracle database the double, float and other types are incorporated into the number data type. As you will see from the data in Confirm, the maximum length isn't always used, e.g. the numbers stored are often shorter.
 

SQL Server

Decimal (10,2) total of 10 digits, 2 of which after the decimal point.

Environment Details

Product Feature: Mapping Issue
                            Application Infrastructure

Downloads

  • No Downloads