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.

Zuletzt veröffentlicht: August 25, 2014

No Product Found

Bug-ID-Nummer	NIM011006
Eingereicht	August 16, 2007
Zuletzt geändert	April 2, 2025
Gilt für	No Product Found
Gefunden in Version	9.2
Behoben in Version	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

Schritte zur Reproduzierung

Bug-ID: NIM011006

Software:

No Product Found

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln

Workaround

Schritte zur Reproduzierung

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Weitere Informationen zu diesem Thema erkunden