Subject | Re: [Firebird-Java] Re: getObject and blob |
---|---|
Author | Marczisovszky Daniel |
Post date | 2002-03-26T09:16:34Z |
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,
Daniel
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,
Daniel