Results 1 to 2 of 2

Thread: Clob Vs Blob

  1. #1
    Join Date
    May 2003
    Posts
    3

    Unanswered: Clob Vs Blob

    Hi all,

    1. Could you please tell me the advantages of CLOB over BLOB( i have searched in most of the sites but there is no clear definition except --> CLOB is used to store character data and BLOB is used to store Binary data. Could you please elaborate it)

    2. Suppose i have a text file(EDI format) if i store it in CLOB how much space it will take and will it take the same space if stored in BLOB.

    3. Will there be any performance improvement in Storing/retreiving a text file in CLOB instead of storing it in a BLOB.

  2. #2
    Join Date
    May 2003
    Location
    Edmonton Alberta Canada
    Posts
    41
    clob is for text like arrays, blobs for binary objects like images

    cheers

Posting Permissions

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