Convert datatype Text to image

roopaksr · August 16th, 2008, 07:16 AM

Dear friends,
I have one column in SQL Server 2000, and this column datatype is text. I am storing as string in this filed, this string was converted from Image. Now I have to convert from this text to Image and copy the image into hard disk. How to do this procedure?

September 6th, 2008, 07:00 AM

What do you mean by these two lines? Can you please elaborate?

Code:

I am storing as string in this filed, this string was converted from Image.

Old Pedant · September 6th, 2008, 03:02 PM

If you mean you made a mistake and stored the binary data as string in a TEXT field, you may be stuck. There is no guarantee that the binary data was stored correctly and not transformed via the current encoding to a string.

But you could *try*. Just change the field type from TEXT to VARBINARY (or BLOB or whatever) and see if it works. But don't be surprised if it doesn't.