>
> I get that it is working for you. Have you tried putting the contents
> into a binary blob then searching? Have you then tried moving the
> contents to a text blob from the binary blob via an update statement
> and then searching?
>
> I can't explain why it works for you and not for me. I can just assure
> you that it doesn't work for me.

the first issue to solve was that it works in text at all. I wasn't ever
talking about the issue of transferring.
You talked about a bug in the searching - not the transfer.
If you can confirm that searching works in a text blob then we can approach
the transfer. Not much good doing a transfer if it still doen't work is it?
If you can place the contents, even manually, into the text blob, and it
still doesn't respond to CONTAINING then we have to work out if indeed it's
an encoding issue.
Alan

>
> I have a feeling Helen is right. If I wouldn't have started out with
> this data being saved in a binary blob, this problem would not exist.
> There are about 250,000 records in this table. I am going to write a
> program tomorrow that saves the contents of this field to disk, then
> reloads it into a text type blob. I'll report my results if you guys
> care or think it helps in any way.
>