How to update the varbinary value with null in an image field in SQL Server 2008?

Question

I have uploaded an image and stored into image field in database, that image is stored as 0xFFD8FFE. When I am trying to update the above with null as getting an exception called:

The datatypes image and varbinary(max) are incompatible in the equal to operator

I want to change the above value to null.

Brent Ozar · Accepted Answer · 2011-01-28 22:10:02Z

3

Just set it to null with an update statement:

UPDATE dbo.MyTable
  SET MyFieldName = NULL
  WHERE MyPrimaryKey = 12345

answered Jan 28, 2011 at 22:10

Brent Ozar

13.3k16 gold badges76 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

RouR · Accepted Answer · 2011-11-25 08:36:18Z

1

update organisation set logo= null where logo like 0xFFD8FFE00010

answered Nov 25, 2011 at 8:36

RouR

6,3563 gold badges36 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to update the varbinary value with null in an image field in SQL Server 2008?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related