DB2 data types |
|
Release 9.3 |
ArcGIS data type | DB2 data type | Notes |
---|---|---|
OBJECTID | INTEGER(4) | NOT NULL |
SHORT INTEGER | SMALLINT(2) | |
LONG INTEGER | INTEGER(4) | |
FLOAT | DECIMAL(31,8) | |
DOUBLE | DECIMAL(31,8) | |
TEXT | VARCHAR(n) | |
DATE | TIMESTAMP | |
BLOB | BLOB | |
GUID | CHARACTER(38) | |
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 |