当前位置：网站首页>Cannot compare or sort text, ntext, and image data types

Cannot compare or sort text, ntext, and image data types

2022-08-05 07:11:00 【51CTO】


Recently, when developing a file management system, I encountered a problem: the original local database is SQL2008, and there is a field SharedUserId of nvarchar(max) type, which is occasionally queriedSQL statement used...AND SharedUserId

---------------------------------------
Microsoft Internet Explorer
--------------------------------------
The text, ntext, and image data types cannot be compared or sorted unless the IS NULL or LIKE operators are used.(System.Exception)
--------------------------------------
OK
--------------------------------------
  • 1.
  • 2.
  • 3.
  • 4.
  • 5.
  • 6.
  • 7.

So, I even changed the local database field type to text, and then tested it, and a similar error was reported (even the SQL2008 is in English):

---------------------------------------
Microsoft Internet Explorer
--------------------------------------
The data types text and varchar are incompatible in the not equal to operator.(System.Exception)
--------------------------------------
OK
--------------------------------------
  • 1.
  • 2.
  • 3.
  • 4.
  • 5.
  • 6.
  • 7.

After searching on the Internet, the original query statement is slightly modified, and it works: ...AND SharedUserId replaced by ...AND DATALENGTH(SharedUserId) > 0 AND SharedUserIdIS NOT NULL

原网站

版权声明
本文为[51CTO]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/217/202208050639134694.html

边栏推荐

猜你喜欢

随机推荐