Adding text field changing size to "max"

1120
6
Jump to solution
11-10-2014 09:45 AM
Highlighted
New Contributor III

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

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
Esri Esteemed Contributor

Maybe it has something to do with this issue:

Text data type and Length size problem

Kind regards, Xander

View solution in original post

Reply
0 Kudos
6 Replies
Highlighted
Esri Esteemed Contributor

Maybe it has something to do with this issue:

Text data type and Length size problem

Kind regards, Xander

View solution in original post

Reply
0 Kudos
Highlighted
New Contributor III

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.

Reply
0 Kudos
Highlighted
Regular Contributor III

Version of ArcGIS Desktop? Complete version of DBMS used?

Reply
0 Kudos
Highlighted
New Contributor III

ArcMap 10.2.0.3348, License Type: Standard

GeoDatabase (MSSQL):  10.2.1

Reply
0 Kudos
Highlighted
Regular Contributor III

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)

Reply
0 Kudos
Highlighted
New Contributor III

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

Reply
0 Kudos