laptop and a wrench

漏洞

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.

上次发布: August 25, 2014 No Product Found
漏洞 ID 编号 NIM011006
已提交August 16, 2007
上次修改时间April 2, 2025
适用范围No Product Found
找到的版本9.2
修正版本9.3
状态Fixed

解决办法

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

重现步骤

漏洞 ID: NIM011006

软件:

  • No Product Found

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项