--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:

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

Ok, wrote the program to save to disk and then reload a temporary text blob with the file from disk. Still no luck.

So.. since I had the files on disk, I did as Helen recommended and opened the file with Notepad and clicked "Save As" and the encoding on these files is Unicode.

What now?