English

FAQ: Why is the result of translating a shapefile boolean field into ArcSDE using ArcCatalog different than the shp2sde Admin command?

Question

Why is the result of translating a shapefile boolean field into ArcSDE using ArcCatalog different than the shp2sde Admin command?

Answer

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.

Type: Logical
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.