Hello all,
I am currently working on an implementation of Interbase into crossdb
(a standard Java™ API for writing object oriented SQL statements that
are database independent. ).

In order to have a variable size textfield (LONGVARCHAR), I used BLOB
in Interbase, since this is the only variable size field. The API
uses Strings to store the LONGVARCHAR variables. If I try to write a
long String to an Interbase blob field, I get this error:

interbase.interclient.SQLException: [interclient][interbase]
conversion error from string "BLOB"

I need to figure out how I can store this string into the BLOB field.
So far the only idea is, to get the metadata and figure out what
datatype the field has. If it is blob, I use the appropriate method,
if it is String, I store it as String.

If I remember right, Firebird already supports the string - blob
conversion, but Interbase isn't. For your info, I am using the
Firebird InterServer 2.01 and the Firebird interclient.jar (Nov-6-
2001, 375 KB).

Any hints are appreciated. TIA

Gunter