Subject Re: [firebird-support] Error copying text from BLOB to varchar
Author Ivan Prenosil
> 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.

Can't you just search on the blob field directly ?

SELECT * FROM mytab WHERE myblobfield CONTAINING 'longstreet';


> 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" '.