Text data type and Length size problem

Question

When importing a table into SDE/Oracle 11g instance using AG 10 or 9.3.1 "Table to Table" tool, a field defined as Text, 4000 is converted to Text, 1073741822.  Using SQL Plus to describe the table, it defines it as Type, NCLOB.  The table was originally loaded in SDE using SQL.  There is a similar issue when importing the table into a File Geodatabase.

Has anyone encounter this problem.

Thanks
B!

Bud · Answer

Get maximum text value length of multiple text fields

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

Raj-Chavada · Answer

Nevermind. I got my answer here - https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/data-types-sqlserver.htm

It seems like I can do this by exporting and import database configuration keyword table. The UNICODE_STRING needs set to false "FALSE". This way I can create the text field with field length up to  8000 characters.

Raj-Chavada · Answer

I am experiencing similar issue when creating attribute field with field length - 5000 but with SQL Server 2016 not oracle. For some reason, the SQL Server sets the type - navchar(max) displaying field length of  1073741822.

Can this fixed by applying the same fix?

@JakeSkinner @VinceAngelo