BLOB or CLOB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: BLOB or CLOB

  1. #1
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150

    Cool

    What's the difference between BLOB and CLOB?

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925


    CLOB is similar to the oracle 7 long type, a clob can hold single-byte character data.

    NCLOB stores fixed-width multibyte national character set data.

    BLOB is similar to oracle & lon raw type, a BLOB can hold unstructred binary data.You can store and retrieve the data
    piecewise.

    BFIlEs allow read-only access to large binary files stored outside the oracle database.Unlike other three LOB types, BFile data is stored in a seperate file that is not maintained by oracle.Manipulations to BFILE data do not participate in oracle transactions.They can not be committed or rolled back.

    store text as an image-use BLOB
    store text- use CLOB


    Curtesy to Oracle Forums, Metalink.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Nov 2000
    Posts
    344
    To help you remeber the distictionion, look at the first letter -

    CLOB - C = Character
    BLOB - B = Binary
    NCLOB - N = National (Guess what C is?)

  4. #4
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150
    Suppose I am using the UTF8 Character set, do I need to use NCLOB instead of CLOB?

    Thanks,

    Ed

Posting Permissions

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



Click Here to Expand Forum to Full Width