SQL Server data types |
|
Release 9.3 |
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 | NVARCHAR(n) or VARCHAR(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 |