Subject Fw: Firebird 2.1 and text blobs
Author Martijn Tonies
Jason,

Here's an issue with Firebird 2.1 that, probably, could be easily fixed?

Basically, a text blob in Firebird 2.1 is being returned as DOUBLE
in IBO.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com


> > Martijn Tonies wrote:
> > >
> > > Sorry Adriano, this isn't helping me :-)
> > >
> > > Is it IBObjects, DBW or Firebird that causes this?
> >
> > Firebird now returns the BLOB charset in XSQLDA. As there were no room
> > for this information, it's being returned in sqlscale (previously it
> > always contained zero for blobs).
> >
> > So it seems to me that IBO thinks that if sqlscale is not zero, then
> > this cannot be a blob (even if the reported datatype is SQL_BLOB).
> >
> > I could give you a more precise answer if you provide me with the source
> > code for IBO.
> >
> > Dmitry
>