ArcMap crashes while executing definition query on a text field having length of more than 4000. When the UNICODE_STRING dbtune parameter is set to FALSE, text fields greater than 4000 characters are incorrectly created as SQL Server 'text' columns instead of varchar columns. This causes string comparisons such as definition queries to fail. The = operator does not work the same way on text/ntext data as it does on varchar/nvarchar.

Last Published: August 25, 2014

No Product Found

Bug ID Number	NIM011006
Submitted	August 16, 2007
Last Modified	April 2, 2025
Applies to	No Product Found
Version found	9.2
Version Fixed	9.3
Status	Fixed

Workaround

use the CAST function in the definition query:cast(Color_ID as varchar(8000)) = 'red'the = operator doesn't work the same way on text/ntext data as it does on varchar/nvarchar

Steps to Reproduce

Bug ID: NIM011006

Software:

No Product Found

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Workaround

Steps to Reproduce

Get notified when the status of a bug changes

Discover more on this topic