com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: varbinary is incompatible with text

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by 862805, 1 year ago
Operand type clash: varbinary is incompatible with text
via Stack Overflow by arinte
, 2 years ago
Column 'dbo.device.device_id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
via Google Groups by John Whish, 3 months ago
Error converting data type nvarchar to decimal. I don't get this on ACF9.0.1 against the same database. Looking into this a bit further, it seems that maybe under the hood Railo is using double for "1.11", but MS SQL Server expects a BigDecimal
via Stack Overflow by Abraham Church
, 2 years ago
Arithmetic overflow error converting int to data type numeric.
via Stack Overflow by Mahendiran
, 1 year ago
The request for procedure 'usp_getdelordinvoice' failed because 'usp_getdelordinvoice' is a synonym object.
via Stack Overflow by marcolopes
, 2 years ago
The ntext data type cannot be selected as DISTINCT because it is not comparable.
com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: varbinary is incompatible with text
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 4 weeks ago
4 times, 1 month ago
14 times, 3 months ago
Samebug visitor profile picture
Unknown user
Once, 7 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.