Subject Error copying text from BLOB to varchar
Author robert_hollay
Hi all,

There is a textual BLOB field in a table, where the customer stores
some text (not too long, a few lines of names, addresses, etc...).
Last week the customer came forward with the idea that it would be
very nice if he could make a search on this field. No problem, I said,
I would change the BLOB field into varchar(300) and that's all.
I made a new field in the table, and tried to copy the old data:


but got an error message: 'Overflow occured during data type
conversion. conversion error from string "BLOB" '.

The BLOB and VARCHAR fields have identical character sets.
How can I make this conversion?

TIA, Robert