[ http://issues.apache.org/jira/browse/DERBY-2198?page=comments#action_12460117 ] Yip Ng commented on DERBY-2198: -------------------------------
Try casting the hex literal to a blob. e.g.: create table t1 (i int, b blob); insert into t1 values (1, CAST (X'FFFF' AS BLOB) ); I think these sort of questions can be ask in the user or dev list instead of jira issues. =) > Is it possible to insert a blob column into derby with sql instead of java? > --------------------------------------------------------------------------- > > Key: DERBY-2198 > URL: http://issues.apache.org/jira/browse/DERBY-2198 > Project: Derby > Issue Type: Test > Components: SQL > Environment: Linuxamd64 > Reporter: hai feng li > > I create below 2 tables: > CREATE TABLE clob_tb1 (int_col INTEGER, clob_col CLOB(300)); > CREATE TABLE blob_tb1 (int_col INTEGER, blob_col BLOB(300)); > For the table with clob column, below insert can work well: > insert into clob_tb1 values(1,'This is the first row of the clob table'); > For the table with blob column, below insert can not work: > insert into blob_tb1 values > (1,'0123456789abcdef0123456789abcdef0123456789abcedf'); > I also tried below styles: > insert into blob_tb1 values > (1,X'0123456789abcdef0123456789abcdef0123456789abcedf'); > It can not work either. > Is there a way to do the insert with sql? > Thanks! -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
