--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:

>
> At 11:35 AM 8/05/2009, Alan McDonald wrote:
>
> >Helen, this is content, not a declaration of charset for the blob type.
> >the CONTAINING select works fine for me on a TEXT blob on NONE charset for
> >this content.
>
> With UTF-16 data?
>
> Remember, he started out with this data in a binary blob...would not have been transliterated when he wrote it to a text blob...so when he passes an ansi (or UFT8) search string, he's not getting a match.
>
> ./hb
>

Thank you both for your help.

Do you think this would work if I saved the contents of this field to disk for each record, recreated the blob as text type, and then loaded the blob field with the files from disk?

Would this give me a different result than creating a new field and moving the data (update table set newfield = oldfield)?