|Subject||Re: [firebird-support] Error copying text from BLOB to varchar|
> There is a textual BLOB field in a table, where the customer storesCan't you just search on the blob field directly ?
> 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.
SELECT * FROM mytab WHERE myblobfield CONTAINING 'longstreet';
> I made a new field in the table, and tried to copy the old data:
> update MYTABLE set VARCHARFIELD = BLOBFIELD
> but got an error message: 'Overflow occured during data type
> conversion. conversion error from string "BLOB" '.