• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

insert BLOB into informix

 
Santosh Maskar
Ranch Hand
Posts: 226
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 221
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I know nothing of informix, but are you using PreparedStatement?

 
Santosh Maskar
Ranch Hand
Posts: 226
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
actully i need to insert using plain jdbc code, but before that i want to insert from the SQL editor
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 226
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Jeanne,

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


but thanks to your reply.

Thanks
Santosh
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic