Hi,

I already tried

SELECT * FROM mytab WHERE myblobfield LIKE '%longstreet%'

but didn't work as expected (I'm using PHP + FB1.5, and WIN1251).
But now I see that CONTAINING is better because of it's case
insensitivity.
I will try out that. Thanks!

Robert

>
> Can't you just search on the blob field directly ?
>
> SELECT * FROM mytab WHERE myblobfield CONTAINING 'longstreet';
>
> Ivan
>
>
> > 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" '.