Inserting an image file into a database...

How would I do this? What would the datatype be for the field that would hold the image? I have a feeling it is something along the lines of a long binary field, but I don't know what I would do to create such a field.

I would be doing this both in Oracle and in Access through a Java application so the SQL would be more or less the same.

Any help is greatly appreciated.

[b]Discipline[/b] - The desire to do the right thing in the absence of both leadership and consequence.


  • hi,
    in oracle ther is data types called CLOB - character Large obejcts,
    BLOB - binary Large objects,u can store the image files using this data types, as well ther is provision that u can mailtain a image file in a external location and access it thru database query as a table column with this datatype coilumns.for that u have 2 create a directory object as well.
    try it n tell me
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


In this Discussion