Bogue
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.
| Numéro d’ID de bogue | NIM011006 |
|---|---|
| Envoi | August 16, 2007 |
| Dernière modification | April 2, 2025 |
| S’applique à | No Product Found |
| Version trouvée | 9.2 |
| Version de correction | 9.3 |
| Statut | Fixed |
Solution de contournement
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Étapes pour reproduire
ID de bogue: NIM011006
Logiciel:
- No Product Found
Recevoir une notification lorsque le statut d’un bogue change
En savoir plus sur ce sujet
Rechercher des informations associées
Rechercher une formation sur ce sujet
Explorer des pistes et donner un avis
Obtenir de l’aide auprès des experts ArcGIS
Télécharger l’application Esri Support