db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From George H <george....@gmail.com>
Subject Re: can varchar for bit data size limit be exceeded?
Date Thu, 22 Apr 2010 07:02:42 GMT
On Wed, Apr 21, 2010 at 4:00 PM, Knut Anders Hatlen <Knut.Hatlen@sun.com> wrote:
> 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

OK, I guess I could look into that and see what I can make of it.
Thanks for helping me out.

George H

View raw message