Inserting a binary data in an image column.

• John Trevor

  Grasshopper

  Points: 13

  More actions

  April 16, 2008 at 1:33 am

  #185539

  I have a stored procedure through which I am inserting value in a column which is of datatype IMAGE. I am passing binary value to be input in the table through the stored procedure. However, although the insert occurs, the data stored is a different string than the one inserted when I do a SELECT on that table. Any suggestions ?

• GSquared

  SSC Guru

  Points: 260824

  More actions

  April 16, 2008 at 1:31 pm

  #803296

  Have you tried using varbinary(max), instead of image, for the data type? For SQL 2005, that's recommended, and might help with what you're doing.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon