topic Re: Large text fields in Data Management Questions https://community.esri.com/t5/data-management-questions/large-text-fields/m-p/337134#M19166 <HTML><HEAD></HEAD><BODY><SPAN>Hi Don - </SPAN><BR /><BR /><SPAN>If you're working with a file geodatabase, the text field width can be 2,147,483,647 characters - </SPAN><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/File_geodatabase_size_and_name_limits/003n0000007q000000/">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/File_geodatabase_size_and_name_limits/003n0000007q000000/</A><BR /><BR /><SPAN>If you're working with SDE geodatabases, it depends upon the type of RDBMS you're using - </SPAN><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Data_types_in_the_DBMS/003n0000001n000000/">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Data_types_in_the_DBMS/003n0000001n000000/</A><BR /><BR /><SPAN>Good luck!</SPAN><BR /><BR /><SPAN>Robert LeClair</SPAN><BR /><SPAN>Esri-Denver</SPAN></BODY></HTML> Wed, 20 Apr 2011 16:03:34 GMT Robert_LeClair 2011-04-20T16:03:34Z Large text fields https://community.esri.com/t5/data-management-questions/large-text-fields/m-p/337133#M19165 <HTML><HEAD></HEAD><BODY><SPAN>Some dbms support memo fields wherein you can store text beyond the 255 character limit imposed by a standard character field. However ESRI seems to reject all my attempts to use fields of this nature. IS there a field type supported by ESRI which allows more than 255 characters?</SPAN><BR /><SPAN>Thanks</SPAN></BODY></HTML> Wed, 20 Apr 2011 15:49:21 GMT https://community.esri.com/t5/data-management-questions/large-text-fields/m-p/337133#M19165 DonFreeman 2011-04-20T15:49:21Z Re: Large text fields https://community.esri.com/t5/data-management-questions/large-text-fields/m-p/337134#M19166 <HTML><HEAD></HEAD><BODY><SPAN>Hi Don - </SPAN><BR /><BR /><SPAN>If you're working with a file geodatabase, the text field width can be 2,147,483,647 characters - </SPAN><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/File_geodatabase_size_and_name_limits/003n0000007q000000/">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/File_geodatabase_size_and_name_limits/003n0000007q000000/</A><BR /><BR /><SPAN>If you're working with SDE geodatabases, it depends upon the type of RDBMS you're using - </SPAN><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Data_types_in_the_DBMS/003n0000001n000000/">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Data_types_in_the_DBMS/003n0000001n000000/</A><BR /><BR /><SPAN>Good luck!</SPAN><BR /><BR /><SPAN>Robert LeClair</SPAN><BR /><SPAN>Esri-Denver</SPAN></BODY></HTML> Wed, 20 Apr 2011 16:03:34 GMT https://community.esri.com/t5/data-management-questions/large-text-fields/m-p/337134#M19166 Robert_LeClair 2011-04-20T16:03:34Z Re: Large text fields https://community.esri.com/t5/data-management-questions/large-text-fields/m-p/337135#M19167 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Hi Don - <BR /><BR />If you're working with a file geodatabase, the text field width can be 2,147,483,647 characters - <A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/File_geodatabase_size_and_name_limits/003n0000007q000000/">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/File_geodatabase_size_and_name_limits/003n0000007q000000/</A><BR /><BR />If you're working with SDE geodatabases, it depends upon the type of RDBMS you're using - <A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Data_types_in_the_DBMS/003n0000001n000000/">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Data_types_in_the_DBMS/003n0000001n000000/</A><BR /><BR />Good luck!<BR /><BR /><BR /><BR />Robert LeClair<BR />Esri-Denver</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>That's wonderful. Thanks for the info.</SPAN></BODY></HTML> Wed, 20 Apr 2011 17:28:49 GMT https://community.esri.com/t5/data-management-questions/large-text-fields/m-p/337135#M19167 DonFreeman 2011-04-20T17:28:49Z Re: Large text fields https://community.esri.com/t5/data-management-questions/large-text-fields/m-p/337136#M19168 <HTML><HEAD></HEAD><BODY><SPAN>Robert,</SPAN><BR /><BR /><SPAN>I have a question for you related to exceeding a predefined text field length.&nbsp; Is it supposed to be possible for a field to contain more characters than a set limit?&nbsp; I have a FC in a FGDB that is set to 300 characters but some of the records actually contain more than the 300 character limit.&nbsp; How is that possible?&nbsp; When I try to load data from that FC into another one with an identical schema it will not allow those records to transfer.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>Aaron Baumgarden</SPAN></BODY></HTML> Wed, 26 Oct 2011 17:33:50 GMT https://community.esri.com/t5/data-management-questions/large-text-fields/m-p/337136#M19168 AaronBaumgarden 2011-10-26T17:33:50Z