Menu

#3708 Can't delete/update a record in a table with image field in sql server

New
nobody
Medium
Defect
2017-06-15
2017-06-15
No

Hello

I have got a problem with tables containing an image field in sql server.
For example, if I have the following table :
CREATE TABLE "signatures" (
"id" INT NOT NULL,
"name" VARCHAR(50) NOT NULL,
"signature" image
);

I can insert data in the table with HeidiSQL data view, but I cannot delete or update lines : I get an SQL server error "402 The data types image and varbinary are incompatible in the equal to operator".
The generated request is :
UPDATE TOP(1) "DB"."signatures" SET "signature"=0x3200300000006F00 WHERE "id"=2 AND "name"='frfr' AND "signature"=0x320030000000;

HeidiSQL version : 9.4.0.5125
SQL server version : Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19 2012 13:38:57
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Discussion