Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2012

    Unanswered: Query string from Mysql to Oracle

    Hi there,

    I am new to oracle and wish to have some helps here. Currently, I have query which convert the image file into the binary format before store into MySQL database.
    Now, I need the image file to store into the oracle. I just want to make sure/ensure the differences of the query.

    Here the query for MySQL:

    strInsertQuery += formatObj.getHexForFile(formatObj.getDecodeBase64(arrVal.get(i).toString())) + ", ";
    If I want to convert the image into the binary file into oracle db, can I use the same code as above or what changes I need to make
    to get it work in oracle.

    Thanks in advance

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    as logic_earth said in the other forum...
    The code you posted has nothing to do with MySQL. So yes it would work with Oracle. But you don't need to do that, you can store binary data as is. Use BLOB for the column type. | @rudydotca
    Buy my SitePoint book: Simply SQL

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts