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.

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

Comments

  • 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
    bye
    guru
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!

Categories

In this Discussion