ArcGIS Server Banner

SQL Server data types

SQL Server data types
Release 9.3 E-mail This TopicPrintable VersionGive Us feedback
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 SQL Server types in the following table:


ArcGIS data type SQL Server data type Notes
OBJECTID INT(4) NOT NULL
SHORT INTEGER SMALLINT(2)

LONG INTEGER INT(4)

FLOAT REAL

DOUBLE DOUBLE If scale is set to greater than 0 in ArcGIS, the SQL Server data type will be NUMERIC.
TEXT VARCHAR(n) or NVARCHAR(n) The data type is NVARCHAR if your geodatabase stores Unicode text. With NVARCHAR, you can have up to 4000 characters. If you are not using Unicode, text fields are VARCHAR. For VARCHAR, you can have up to 8000 characters. If you create a field with a value larger than the maximum allowed for that data type, the field will be converted automatically to a BLOB type.
DATE DATETIME

BLOB IMAGE

GUID UNIQUEIDENTIFIER(16)

GEOMETRY IMAGE

RASTER IMAGE

See Also

  • About data types
  • About geometry storage types