Enum esriFieldType
- Namespace
- ESRI.ArcGIS.Geodatabase
- Assembly
- ESRI.Server.Geodatabase.dll
Field Types.
[Guid("4CA2D959-5A38-11D2-AABD-00C04FA37585")]
public enum esriFieldType
Fields
esriFieldTypeBigInteger = 1313: 64-bit Integer.
esriFieldTypeBlob = 88: Binary Large Object.
esriFieldTypeDate = 55: Date.
esriFieldTypeDouble = 33: Double-precision floating-point number.
esriFieldTypeGUID = 1010: Globally Unique Identifier.
esriFieldTypeGeometry = 77: Geometry.
esriFieldTypeGlobalID = 1111: Esri Global ID.
esriFieldTypeInteger = 11: 32-bit Integer.
esriFieldTypeOID = 66: Integer representing an object identifier. 32-bit OID has a length of 4 bytes, and 64-bit OID has a length of 8 bytes.
esriFieldTypeRaster = 99: Raster.
esriFieldTypeSingle = 22: Single-precision floating-point number.
esriFieldTypeSmallInteger = 00: 16-bit Integer.
esriFieldTypeString = 4-
4: Character string.
Note
The esriFieldTypeString enumeration value does not define a fixed maximum string length. The supported length depends on the field's configured length, the underlying database management system (DBMS), and the database storage configuration.
String length and storage behavior vary by DBMS. For example:
- SQL Server: Standard VARCHAR(n) supports up to 8,000 bytes, while NVARCHAR(n) supports up to 4,000 UTF-16 byte-pairs. Larger values require the corresponding MAX type, subject to ArcGIS support.
- PostgreSQL: VARCHAR(n) specifies a maximum length in characters rather than bytes.
- Oracle: String field limits depend on the data type, byte or character length semantics, and database configuration.
Large string fields may have additional storage and indexing considerations. Define a field using the smallest length that accommodates the intended data.
For the configured field length, see IField.Length .
esriFieldTypeXML = 1212: XML Document.