Howdy, Stranger!

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

Categories

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

  • n_g_prasadn_g_prasad Member Posts: 1
    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
  • Justin BibJustin Bib USAMember Posts: 0

    _________ < http://forcoder.org /> free ebooks and video tutorials about | MATLAB, Go, JavaScript, C, C++, Scratch, Visual Basic .NET, C#, Objective-C, PL/SQL, Delphi, Java, Swift, Visual Basic, Ruby, Python, Assembly, Perl, R, PHP Fortran, Apex, D, Awk, Erlang, Rust, Scheme, Alice, Kotlin, Lua, F#, Ada, VBScript, Clojure, SAS, COBOL, Hack, Logo, ML, Julia, Crystal, Bash, Dart, LabVIEW, Lisp, Prolog, Transact-SQL, Scala, FoxPro, ABAP | _____

Sign In or Register to comment.