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)