{I hope this doesn't appear in triplicate!}

I have converted a database from Fb/1.5.4 to Fb/2.1RC1. After this,
I performed the steps described in ...\misc\upgrade\metadata\metadata.txt.

Using FlameRobin with the Fb/1.5.4 server works fine, but the
converted database seems to cause troubles.
Let's see the differencies: On Fb/1.5.4, I right-click a table and
choose "select from ...", and look at contents in the Statistics
pane. For a blob field (field REMAKE in table JOURNAL) it shows e.g.:
Field #13: JOURNAL.REMAKE Alias:REMAKE Type:BLOB SUB_TYPE 1
Which is fine, of course.

Now, on the pc with Fb/2.1 (and converted database) I get
Field #13: JOURNAL.REMAKE Alias:REMAKE Type:NUMERIC(18,-21)
and an error:
===============================
*** IBPP::WrongType ***
Context: RowImpl::GetValue
Message: Incompatible types.
BLOB and double
===============================

This seems to happen with blob fields in any table.

There are a lot of text blobs in this database. I hope that I don't
have to fix them all individually!

Note also that IB_SQL shows some (intermittent) problems on this
database as well. See also my message in firebird-devel (Thread: Fb/2.1 RC1).

--
Aage J.