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, 2014No 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