Hello Martijn,

> >> > Regarding 3.1.4 and 3.2.4: I've found this example on how to change the
> >> > blob type:
> >> > UPDATE RDB$FIELDS SET RDB$FIELD_SUB_TYPE = 0
> >> > WHERE RDB$FIELD_NAME=(SELECT RDB$FIELD_SOURCE FROM RDB$RELATION_FIELDS
> >> > WHERE RDB$FIELD_NAME='SOME_TEXT_BLOB_FIELD' AND
> >> > RDB$RELATION_NAME='SOME_TABLE');
> >> > Seems to work without the content getting lost. Sure, it's in the wrong
> >> > format that way, but it seems to be possible to obtaint the content and
> >> > then to save it in the new format. But depending on the choice of the
> >> > way
> >> > to go, this could be irrelevant.
> >>
> >> You are modifying the blob to BINARY, that doesn't sound right.
> >>
> >
> > Yes, didn't look that "healthy" to me too, but has worked and that's what
> > IBExpert (I believe) has made of my attempt to change the sub type
> > manually.
> >
>
> Hopefully not of a text column you still want to use as text?
>

Those are BLOB SUB_TYPE 1 columns, which store RTF-text in them. They have to become BLOB SUB_TYPE 0 columns, as the content will be stored in a different way in the new version.

It seemed to work and after changing the sub type I was able to get the content out of the fields and refill them with the content in the new format... But despite the bad feeling about it: if I have to do the upgrade table by table manually anyway, there won't be any need to do this to the BLOB SUB_TYPE 1 columns anyway.

Thank you,
Patrick