In the meantime, you should be able to use the String function "getByte()" (with the appropriate character coding if necessary) and then use a SerialBlob - new SerialBlob(byte[]).
Donald -------------- Original message ---------------------- From: "Andrew McIntyre" <[EMAIL PROTECTED]> > On 11/28/06, Ray Kiddy <[EMAIL PROTECTED]> wrote: > > > > If one is writing SQL to create tables and insert > > data and one has a BLOB column, how can > > one do this? > > There is not currently a way to do this with just SQL. However, there > is an open JIRA for similar functionality and there has been some > discussion around it. See: > > http://issues.apache.org/jira/browse/DERBY-378 > > http://mail-archives.apache.org/mod_mbox/db-derby-dev/200610.mbox/%3c45410499.80 > [EMAIL PROTECTED] > > Note that from the discussion, the functionality that would be > provided would be a procedure to load the contents of a BLOB from a > file.
