If the UNICODE_STRING configuration parameter is set to TRUE and the text field is 4,000 characters or more, NVARCHAR(MAX) is used. If the UNICODE_STRING configuration parameter is set to TRUE and the text field is 3,999 characters, NVARCHAR is used. If the UNICODE_STRING configuration parameter is set to FALSE and the text field is 8,000 characters or more, VARCHAR(MAX) is used. In an enterprise geodatabase, if the UNICODE_STRING configuration parameter is set to FALSE and the text field is 7,999 characters or fewer, VARCHAR is used. If you create a text field in a SQL Server database from ArcGIS, either nvarchar or nvarchar(max) is used. If you create a varchar or varchar(max) field in a SQL Server database, it will be mapped to the ArcGIS TEXT data type when viewed in ArcGIS. Varchar, nvarchar, varchar(max), nvarchar(max) The ArcGIS type ObjectID is the registered row ID column for the table (or feature class.) Only one may exist per table. Integer with identity property when created in a database Int(4) when created in an enterprise geodatabase If the keyword's RASTER_STORAGE parameter is set to RASTERBLOB, a BLOB column is created if set to BINARY, an int column is created. In enterprise geodatabases, the SQL Server data type that is created depends on the configuration keyword used when you create the raster dataset or mosaic dataset. Raster data types are only supported in geodatabases. Compressed binary data is stored as an INT data type in the database.
#Arcgis 10.3 field data types pro
You cannot create feature classes in ArcGIS Pro that use the compressed binary geometry storage type, but you can view feature classes in ArcGIS Pro that use it. Specify whether to use GEOMETRY or GEOGRAPHY when a feature class is created.ĪrcGIS does not support the following Geometry subtypes: See ArcGIS field data types for more information. The precision and scale specified in ArcGIS can affect the resultant data type created in the database. Other SQL Server data types that can be viewed The last column provides additional information when needed. The third column shows what other SQL Server data types (if any) map to the ArcGIS data type when you view a table that you created outside ArcGIS. The second column lists the SQL Server data type that ArcGIS creates. The first column in the following table lists the ArcGIS data types. Similarly, when you use ArcGIS to copy and paste tables containing unsupported data types from one database to another, ArcGIS only pastes columns that use a supported data type. ArcGIS does not display unsupported data types, and you cannot edit unsupported data types through ArcGIS. When you access a database table through a Database Connection, query layer, or web service, ArcGIS filters out any unsupported data types. How the data in that column is stored in the databaseĪrcGIS works with specific data types.What operations you can use on the data in that column.What values you can store in the column.When you create a table or add a column to a table in a database, you define a specific data type for the column.