I add a text field of size 5000 to an existing table using arcmap. All looks good. Publish the table within a service and the service reports it as:
NOTES ( type: esriFieldTypeString , alias: NOTE , editable: true , nullable: true , length: 1073741822 )
Looking at the table in arcmap the size is now showing as 1,073,741,822. Anyone else have this issue and know what I do to fix it? The service on the table does not work unless I remove that field.
Thanks,
Aaron
Maybe it has something to do with this issue:
Text data type and Length size problem
Kind regards, Xander
Reading the link above I found out that the make size for a NVARCHAR field in my mssql database was 4000. MS's site said to deduct 2 from the length so it will not create as size max.
FNOTES ( type: esriFieldTypeString , alias: FNOTES , editable: true , nullable: true , length: 3998 )
Thanks for the help. The service is working.
ArcMap 10.2.0.3348, License Type: Standard
GeoDatabase (MSSQL): 10.2.1
By "Complete version of DBMS used?", I meant the backend database version (e.g: SQL Server 2012, Oracle 11.2.0.3, PostgreSQL 9.0.5, etc)
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)
I got that by running the command "select @@version".
Maybe it has something to do with this issue:
Text data type and Length size problem
Kind regards, Xander