Subject Re: [Firebird-Java] Re: getObject and blob
Author Marczisovszky Daniel
r> probably, the BLOB has infinite capacity, while BINARY has some limit
r> specified during schema definition.

Actually this may be true, I'm trying to get the ANSI/ISO SQL92
specification to see what does it say about this. But while BINARY may
have limits, VARBINARY (or maybe LONGVARBINARY - which are also JDBC
data types) surely do not have, and they exactly the same as BINARY.

r> I completely agree with you that driver has to be consistent in this
r> question. I will try to fix this problem.

Let's vote :))

Seriously, I believe that the BLOB type in Firebird is actually the
BINARY type with a wrong name...

Best wishes,