laptop and a wrench

Bug

When creating multiversioned view for feature class with nvarchar(n), n is doubled to 2n thus limiting the maximum nvarchar field length to 2000 if it needs to be incorporated in a multiversioned view.

Last Published: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM046752
SubmittedJuly 8, 2009
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found9.3
Operating SystemWindows OS
Operating System Version2003
Version Fixed9.4
StatusFixed

Workaround

If the user sets the UNICODE_STRING value to "FALSE" in the Dbtune, then every data created that point onwards will be created with Text field as VarChar instead of Nvarchar field type. With this setting user would be able to create a field upto length 8000 instead of Nvarchar limiation of 4000. Also, the multiversioned view is created successfully without any issue of length overrun.

Steps to Reproduce

Bug ID: NIM046752

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options