topic Re: Max Text Field Length in Geodatabase Questions

Max Text Field Length

RickeyFight — Tue, 18 Aug 2015 16:37:32 GMT

I have a layer in SDE Feature Class that I need to expand the text length.

I currently have 600 but I need to expand it to 1500.

According to ArcGIS Help 10.1 I can expand it to 2,147,483,647.

I am afraid that it will slow down the database and webservice.

I was wondering if anyone has field lengths 1000 or bigger and how your database handles it.

Thanks

Re: Max Text Field Length

BlakeTerhune — Tue, 18 Aug 2015 18:33:43 GMT

Are you in Oracle or SQL Server? What version?

Re: Max Text Field Length

RickeyFight — Tue, 18 Aug 2015 18:50:47 GMT

SQL Server version 2012

Re: Max Text Field Length

ChadKopplin — Wed, 19 Aug 2015 16:30:02 GMT

Hey Rickey could you keep the field length at a shortened name, and then add the long name as an alias? I do not know if this would have an effect on the performance as well. In earlier versions of geodatabases we were limited to the number of charters in field names, and this was a way to get around that limitation. I am not sure if the database would look at the alias differently from the actual name. Thank you.