Informix data types

Informix data types
Release 9.3

Note:This topic was updated for 9.3.1.

When you create a feature class or table in ArcGIS, there are 11 different data types available for each column. These types are mapped to Informix types in the following table:

ArcGIS data type	Informix data type	Notes
OBJECTID	INT(4)	NOT NULL
SHORT INTEGER	SMALLINT(2)
LONG INTEGER	INT(4)
FLOAT	DECIMAL(32)
DOUBLE	DECIMAL(32)
TEXT	VARCHAR(n)
DATE	DATETIME
BLOB	BLOB
GUID	CHAR(8)
GEOMETRY	ST_GEOMETRY	ST_Geometry is a superclass. The actual data subtype created (such as ST_Multilinestring or ST_Point) depends on what type of feature class you create, whether as polygon, line, point, multipoint, or multipatch.
RASTER	BLOB

Informix data types

Informix data types

See Also