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

>
> At 11:33 AM 20/12/2006, you wrote:
> >Hi,
> >
> >I inherited a database where they created a blob field as type 2.
>
> Blob sub_type 2 is a system subtype. It should NEVER be applied to
> user data. User-defined subtypes should have negative numbers.
>

Yes I know that. They also created a lot of CLOB (sub type 1 fields)
as BLOB (sub type 0 fields). So that is a major issue too. Any
suggestion on how to convert Sub Type 0 and 2 to Sub Type 1?

And thanks for the suggestion. I am working on it now.