Blob field in Interbase 5

hi all :
i have a problem to move blob fields from Interbase5 to Oracle8i,
first i dont know what field in Oracle DB will be the replacement for The Blob type i use in Inetrbase(Borland's DB supplied with delphi), can anybody help.
mostafa

Comments

  • : hi all :
    : i have a problem to move blob fields from Interbase5 to Oracle8i,
    : first i dont know what field in Oracle DB will be the replacement for The Blob type i use in Inetrbase(Borland's DB supplied with delphi), can anybody help.

    Oracle has a BLOB type.


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

  • : : hi all :
    : : i have a problem to move blob fields from Interbase5 to Oracle8i,
    : : first i dont know what field in Oracle DB will be the replacement for The Blob type i use in Inetrbase(Borland's DB supplied with delphi), can anybody help.
    :
    : Oracle has a BLOB type.
    :
    :
    : [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]
    :
    :

    hi,
    yes i know that oracle has a blob data type , but it has a major problem that only one field Blob is allowed in the table, and i have three or four Blob field in one table what can i do?
    only CLOBs can be more than one fields at a table
    mostafa

  • : hi,
    : yes i know that oracle has a blob data type , but it has a major problem that only one field Blob is allowed in the table, and i have three or four Blob field in one table what can i do?
    : only CLOBs can be more than one fields at a table
    : mostafa

    Well, I'm using Oracle9i and I can create tables with multiple BLOBs.


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

  • : : hi,
    : : yes i know that oracle has a blob data type , but it has a major problem that only one field Blob is allowed in the table, and i have three or four Blob field in one table what can i do?
    : : only CLOBs can be more than one fields at a table
    : : mostafa
    :
    : Well, I'm using Oracle9i and I can create tables with multiple BLOBs.
    :
    :
    : [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]
    :
    :
    thanks , i solved the problem on another way,
    i used Long Raw type instead.
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