db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: can varchar for bit data size limit be exceeded?
Date Wed, 21 Apr 2010 13:00:32 GMT
On 04/21/10 10:17 AM, George H wrote:
> Thanks for the extra info. I guess I am still stuck. I have then
> another question, how does one insert large BLOBs (ie., 1MB size) into
> derby just from the IJ console?  I know we "shouldn't" compare derby
> to mysql but with mysql I can insert bytes into a BLOB column by
> forming a very very very long SQL insert statement and just place the
> bytes in there or put them in hex format. Doesn't derby have a
> facility to do something like this? or is a prepared statement the
> only way to go about this?
>   

I don't think there is a way to do this from IJ. Except, perhaps, if you
could live with reading the contents of the BLOB from a file with the
import procedures
(http://db.apache.org/derby/docs/10.5/tools/ctoolsimport16245.html).

-- 
Knut Anders


Mime
View raw message