insert BLOB into informix

[Santosh Maskar]

anybody know how to insert the blob in infromix

create table blobtest( b1 blob)

insert into blobtest values (b1 ???)


thanks you
santosh
[ March 11, 2005: Message edited by: Santosh Maskar ]

[Horatio Westock]

I know nothing of informix, but are you using PreparedStatement?

  
PreparedStatement pstmt = con.prepareStatement("INSERT INTO blobtest (b1) VALUES (?)");
 
pstmt.setBlob(1, <a href="http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Blob.html" target="_blank" rel="nofollow">theBlob</a>)

[Santosh Maskar]

actully i need to insert using plain jdbc code, but before that i want to insert from the SQL editor

[Jeanne Boyarsky]

Santosh,
If it was a clob you could use the varchar syntax to insert. As far as I know, it isn't really possible to type binary.

[Santosh Maskar]

Thanks Jeanne,

i am googling on this, there is somthing called as create blob_id


but thanks to your reply.

Thanks
Santosh