Could not Insert into field of datatype BLOB

Faiz · Post by **Faiz** » Wed Jan 10, 2001 1:37 pm

Hi,
I got the following error when inserting data into a field of datatype BLOB. The others were inserted correctly.

FTN type 82 (varblobi): cannot convert to SQL type; assuming byte in the function vsvtx_setparam

I am selecting the data from a BLOB field and inserting it into another BLOB field when this error occured.
Any solutions???

Regards,

Post by **John** » Wed Jan 10, 2001 2:51 pm

The easiest thing to do is when you select it convert it to varchar first, so rather than:

SELECT BlobField from Table;

SELECT convert(BlobField, 'varchar') BlobField from Table;

goddess · Post by **goddess** » Thu Mar 22, 2001 12:57 pm

Just wanted to let you know this was very helpful.
Thanks,
Joy