While ArcSDE does, ArcGIS Desktop and ArcGIS Server do not support BIGINT (64-bit integer)
datatypes (which is why INT64TYPES is disabled by default).
- V
This post is from 2012, but is there a newer response or update on the 64-bit integer types being usable?
I'm extracting data from my legacy data > converting it to use in ArcGIS Pro
Large Int = all our table_ID fields. Will I have to continue to convert to float or int? Which one is suggested Float or Int?
I wish discussion's from 6 years ago were not first in my search results
I'm not aware of any changes to type support in the last six releases of ArcGIS. I haven't tried to see if ArcGIS Pro handles bigint types.
Using either integer or double is problematic in terms of primary keys. Neither can capture the full range of bigint values. If there are no values which exceed 2^31-1, then you should certainly use an integer type. If the values exceed two billion, I'd recommend considering either hi/lo integers as a compound key, or using UUID (128-bit) with the 64-bit integer mapped to the lower half of the range. After that would be ASCII text, and then double, since float equivalence is fundamentally unreliable.
- V