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

>
> >
> > Is there a way to change a blob field from sub_type 1 to sub_type 0
> > without losing the data in the column? I have tried alter table alter
> > column but the engine is not letting me change it. Perhaps I can
> > modify some system tables?
> >
> >
>
> don't do a system table mod
> create a new field, update the new from old then drop the old.
> If you want the same name, then do it again with the original field name
> ALan
>

ok, tried that. turns out the problem I am trying to fix remains. I have the contents of an XML file in this blob field. When I am viewing the contents through SQLHammer or even issuing SQL against the field doing a "Blob field like '%SomeValue%'" I am not getting any results. I know however that "SomeValue" is contained within the XML file.

Any ideas?