How to store a string in image type column in SQL Server Using SqlParameter

Question

I have a SQL Server database, and I want to store in image type column some string.

I'm trying to do the following :

SqlParameter myparam = new SqlParameter("@myparam", "VeryLongString");
myparam.SqlDbType = SqlDbType.Image;

when I add it to the command and then execute it, I get the following error :

Failed to convert parameter value from a String to a Byte[]

What seems to be the problem ?

thanks in advance

Justin Niessner · Accepted Answer · 2010-10-24 20:43:20Z

5

An Image field in SQL Server stores a byte array (the bytes that make up the image), not a string.

If you're truly trying to pass in a very long string, you should use SqlDbType.Text.

answered Oct 24, 2010 at 20:43

Justin Niessner

246k40 gold badges416 silver badges546 bronze badges

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

1 Comment

marc_s Over a year ago

Plus, the IMAGE datatype has been deprecated with SQL Server 2005 - if you need large text, use VARCHAR(MAX) - if you nee large binary storage, use VARBINARY(MAX).

Collectives™ on Stack Overflow

How to store a string in image type column in SQL Server Using SqlParameter

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related