Is This Content Helpful?
We're glad to know this article was helpful.
Why is the result of translating a shapefile boolean field into ArcSDE using ArcCatalog different than the shp2sde Admin command?
ArcView 3.x uses the dBASE format as the underlying database file format. The dBASE format supports a boolean field type in the format below.
Data Input: ? Y y N n T t F f; ? when not initialized.
Using 'shp2sde' to convert a shapefile into ArcSDE converts the data to a string type containing the characters T, F, or ?.
ArcGIS converts the boolean field type into a Short Int field with the values of 0 or 1.
The ArcSDE administration commands pre-date the existence of ArcGIS. This inconsistency has been recorded as a known issue.