topic Re: Adding text field changing size to "max" in Geodatabase Questions

Adding text field changing size to "max"

AaronHeyman — Mon, 10 Nov 2014 17:45:16 GMT

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

Re: Adding text field changing size to "max"

XanderBakker — Mon, 10 Nov 2014 17:49:27 GMT

Maybe it has something to do with this issue:

Text data type and Length size problem

Kind regards, Xander

Re: Adding text field changing size to "max"

AsrujitSengupta — Mon, 10 Nov 2014 17:49:31 GMT

Version of ArcGIS Desktop? Complete version of DBMS used?

Re: Adding text field changing size to "max"

AaronHeyman — Mon, 10 Nov 2014 18:17:26 GMT

ArcMap 10.2.0.3348, License Type: Standard

GeoDatabase (MSSQL): 10.2.1

Re: Adding text field changing size to "max"

AsrujitSengupta — Mon, 10 Nov 2014 18:23:16 GMT

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)

Re: Adding text field changing size to "max"

AaronHeyman — Mon, 10 Nov 2014 18:31:15 GMT

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)

Apr 2 2010 15:48:46

Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)

I got that by running the command "select @@version".

Re: Adding text field changing size to "max"

AaronHeyman — Mon, 10 Nov 2014 18:55:15 GMT

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.

Re: Adding text field changing size to "max"

Bud — Mon, 28 Oct 2024 18:24:47 GMT

Get maximum text value length of multiple text fields

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