Howdy, Stranger!

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

Categories

Blob field in Interbase 5

GhostBehindCodGhostBehindCod Member Posts: 8
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

  • infidelinfidel Member Posts: 2,900
    : 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]

  • GhostBehindCodGhostBehindCod Member Posts: 8
    : : 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

  • infidelinfidel Member Posts: 2,900
    : 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]

  • GhostBehindCodGhostBehindCod Member Posts: 8
    : : 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.