Select to view content in your preferred language

Max Text Field Length

4189
3
08-18-2015 09:37 AM
RickeyFight
MVP Regular Contributor

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

0 Kudos
3 Replies
BlakeTerhune
MVP Regular Contributor

Are you in Oracle or SQL Server? What version?

0 Kudos
RickeyFight
MVP Regular Contributor

SQL Server version 2012

0 Kudos
ChadKopplin
Frequent Contributor

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.

0 Kudos