Adding text field changing size to "max"

[AaronHeyman]

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

[XanderBakker · Accepted solution]

Maybe it has something to do with this issue:

Text data type and Length size problem

Kind regards, Xander

[AaronHeyman]

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.

[AsrujitSengupta]

Version of ArcGIS Desktop? Complete version of DBMS used?

[AaronHeyman]

ArcMap 10.2.0.3348, License Type: Standard

GeoDatabase (MSSQL):  10.2.1

[AsrujitSengupta]

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)

[AaronHeyman]

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". 

[Bud]

Get maximum text value length of multiple text fields

Idea: Import Table — Set text field length to input field's max text value length